could be expensive
as well.
Thanks,
Sean
On Thu, Aug 5, 2010 at 2:11 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Sean Chen zysc...@gmail.com wrote:
1, delete records ...
2, insert records ...
if I add vacuum analyze in-between this two steps
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 add
