PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1302 > Logged by: Alex Koh > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.3.2 > > Operating system: Linux Redhat 8 > > Description: Vacuumdb and vacuumlo should disable statement_timeout > > Details: > > IMHO vacuumdb and vacuumlo should disable statement_timeout before vacuuming > the database. This should prevent timeouts when vacuuming large tables like > pg_largeobject.
If you have set statement_timeout globally you should expect such problems. That parameter is primarily for per-session use or per-user use using ALTER USER and not to be set for administrators. If you really want a fix, use ALTER USER to turn it off for the super-user. -- 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 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
