Request to have VACUUM ignore cost based limits - Mailing list pgsql-general

From Karl O. Pinc
Subject Request to have VACUUM ignore cost based limits
Date
Msg-id 1139455089l.20096l.31l@mofo
Whole thread Raw
Responses Re: Request to have VACUUM ignore cost based limits  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Just had a situation where a database was reloaded and needed to
be vacuum analyzed before it could be used.  I believe the
cost-based vacuum delay slowed this down considerably.
(I could be wrong, but there was darn little load on the
system...)

It would have been nice to have an option to SQL's VACUUM that would
ignore the cost-based delays so as to bring that database back
to life as rapidly as possible.  (Likewise the vacuumdb shell
command.)

Regards,

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

P.S. Thought I'd post here rather than to the deveoper's
list to get some general feedback.


pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Confirming the autovacuum daemon is running
Next
From: Rodolfo Campos
Date:
Subject: Re: Insert into other database