update will bloat?

Question

update will bloat?

digoal opened this issue 9 years ago · 3 comments

select count(*) from (select pgv_insert('package1','hello',row(id,'digoal'::text,11111111,'2016-01-01'::date)) from generate_series(1,10000000) t(id) ) t ;

select count(*) from (select pgv_update('package1','hello',row(id,'test1'::text,id,'2016-01-02'::date)) from generate_series(1,10000000) t(id) ) t ;

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1161 digoal 20 0 6548248 6.117g 142340 S 0.0 9.7 2:25.63 postgres: postgres postgres [local] idle

res biger and biger when i update ;

Answer 1 · 2016-08-19T11:20:50.000Z

Thank you! I will check it.

Answer 2 · 2016-08-19T11:42:40.000Z

Thank you for the issue! Fixed. Check please.

Answer 3 · 2016-08-20T12:16:54.000Z

Thank you, it ok now .