Marcin Mañk <marcin.mank@xxxxxxxxx> 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
