Re: [PERFORM] vacuum performance on insert

2010-08-06 Thread Sean Chen
e I would think disk could be expensive as well. Thanks, Sean On Thu, Aug 5, 2010 at 2:11 PM, Tom Lane wrote: > "Kevin Grittner" writes: >> Sean Chen wrote: >>> 1, delete records ... >>> 2, insert records ... >>> >>> if I add "vacuu

[PERFORM] vacuum performance on insert

2010-08-05 Thread Sean Chen
Hi, I'm curious -- does "vacuum analyze e.g. table1" improve performance on "insert into table1 ...". I understand the vacuum analyze helps out the query -- select, etc., but just not quite sure on insert. Specifically, I'm doing the following. 1, delete records ... 2, insert records ... if I ad