Re: VACUUM DELAY
От | Bruce Momjian |
---|---|
Тема | Re: VACUUM DELAY |
Дата | |
Msg-id | 200408100205.i7A25tb00362@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: VACUUM DELAY (Gaetano Mendola <mendola@bigfoot.com>) |
Список | 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 по дате отправления: