Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group