Re: Autovacuum vs statement_timeout

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Alvaro Herrera wrote:
>> Hmm, AFAIR subsequent investigation led to the discovery that autovacuum
>> is not affected by statement_timeout.

> Right -- see
> http://thread.gmane.org/gmane.comp.db.postgresql.devel.general/80044/focus=93847

Or even more to the point, look into autovacuum.c:
/* * Force statement_timeout to zero to avoid a timeout setting from * preventing regular maintenance from being
executed.*/SetConfigOption("statement_timeout", "0", PGC_SUSET, PGC_S_OVERRIDE);
 

> So your documentation changes are incorrect.

Indeed.  But wasn't the start of this thread a mention that pg_dump
ought to have a similar defense?  AFAIR it does not, so there's still
a small TODO.
        regards, tom lane