Re: Autovacuum vs statement_timeout - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Autovacuum vs statement_timeout
Date
Msg-id 20070418154052.GB19598@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum vs statement_timeout  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
> > Tom Lane wrote:
> > > I seem to remember that we'd agreed that autovacuum should ignore any
> > > globally set statement_timeout, on the grounds that a poorly chosen
> > > setting could indefinitely prevent large tables from being vacuumed.

FWIW in testing, I just noticed that autovacuum does not pay attention
to statement_timeout anyway, because it is only set in
start_xact_command, which is used for interactive commands only, not in
autovacuum.  So there's no need to patch anything.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum vs statement_timeout
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum vs statement_timeout