Re: Autovacuum vs statement_timeout

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Subject: Re: Autovacuum vs statement_timeout
Date: 2007-03-31 22:36:01
Message-ID: 200704010036.01953.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

On a vaguely related matter, should programs such as pg_dump, vacuumdb,
and reindexdb disable statement_timeout?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-31 23:10:08 Macros for typtype (was Re: Arrays of Complex Types)
Previous Message korryd 2007-03-31 22:14:38 Re: Last minute mini-proposal (I know, I know)forPQexecf()