Sean Chen wrote:
> Now from what you mentioned below, do you know what's the cost of
> postgres requesting new disk space from OS?
Depending on your OS and its version, your file system, your mount
options, and your disk subsystem (and its firmware revision), there
could be various effects --
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.
"Kevin Grittner" writes:
> Sean Chen 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 de
Sean Chen 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 between those
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
