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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
