Re: Concurrent VACUUM and ANALYZE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Concurrent VACUUM and ANALYZE
Date
Msg-id 20922.1216693161@sss.pgh.pa.us
Whole thread Raw
In response to Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Concurrent VACUUM and ANALYZE  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> The case I'm looking at is a large table which requires a lazy vacuum,
> and a zero vacuum cost delay would cause too much I/O.  Yet, this
> table has enough insert/delete activity during a vacuum, that it
> requires a fairly frequent analysis to maintain proper plans.  I
> patched as mentioned above and didn't run across any unexpected
> issues; the only one expected was that mentioned by Alvaro.

I don't find this a compelling argument, at least not without proof that
the various vacuum-improvement projects already on the radar screen
(DSM-driven vacuum, etc) aren't going to fix your problem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Concurrent VACUUM and ANALYZE
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Concurrent VACUUM and ANALYZE