hi, thank you for the reply.
I ran a number of tests to try to make sense of this.
When I ran with or without vacuum, the number of disk io operations,
cache operations etc. gathered from pg_stat table for the insertions
are pretty much the same.
So I don't see vacuum reduce disk io operations.
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
Sean Chen zysc...@gmail.com wrote:
1, delete records ...
2, insert records ...
if I add vacuum analyze in-between this two steps, will it help
on the performance on the insert?
Assuming there are no long-running transactions which would still be
able to see the deleted rows, a VACUUM
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, will it help
on the performance on the insert?
Assuming there are no long-running transactions which would