Re: VACUUM DELAY - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: VACUUM DELAY
Date
Msg-id 200408100205.i7A25tb00362@candle.pha.pa.us
Whole thread Raw
In response to Re: VACUUM DELAY  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
Gaetano Mendola wrote:
> However I think is annoying to write:
> 
> set vacuum_cost_delay = 100;
> vacuum table <big_huge>;
> set vacuum_cost_delay = 0;
> set <whatelse>;
> vacuum table <night_table>;
> ....
> ....

Well, you are already seting it to zero for night, so why not just set
it to non-zero for day?  Seems the same to me, or set it to non-zero in
postgresql.conf and set it to zero at night.

> or even better:
> 
> psql -c "set vacuum_cost_delay = 100; vacuum analyze;"
> 
> and what about the utility vacuumdb ?

Anyone using the utility command can use PGOPT to set the GUC I think. 
Maybe we should mention that in the manual page.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PITR - Some data is not recovered.
Next
From: Kevin Brown
Date:
Subject: Re: Tablespace issues (comment on ,moving indexes)