Marcin Mañk <[EMAIL PROTECTED]> writes: > Hello. > I have an unconfirmed feeling that autovac does not like system-wide > statement_timeout. I.e. when I in some panic move set system-wide > statement_timeout to 90 seconds, autovac stopped working (I do not know for > 100% if there is a dependency). > > Ups... Now I checked that pg_dump has the same issue. and vacuumdb. This is > all on 8.1.4 . > > Yeah, system-wide statement_timeout is not much of a brilliant idea :(
Ok so why don't you exempt user postgres and/or any other roles known to run lengthy jobs? alter role postgres set statement_timeout to 0; > Pozdrawiam > Marcin Mañk > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > -- ------------------------------------------------------------------------------- Jerry Sievers 305 854-3001 (home) Production Database Administrator 305 321-1144 (mobil WWW E-Commerce Consultant ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
