Request to have VACUUM ignore cost based limits

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Request to have VACUUM ignore cost based limits
Date: 2006-02-09 03:18:09
Message-ID: 1139455089l.20096l.31l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)meme(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodolfo Campos 2006-02-09 03:36:44 Re: Insert into other database
Previous Message Karl O. Pinc 2006-02-09 00:31:57 Re: Confirming the autovacuum daemon is running