Warren Little wrote: > Is there anyway to modify the statement_timeout value set > in postgresql.conf we creating a connection? > I would like to have the value set to something like 60 seconds on a > regular basis but my vacuumdb statements run longer and timeout without > completing the vacuum
Sure, use SET statement_timeout = 60000 in your session before the vacuum. -- 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 8: explain analyze is your friend
