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

Autovacuum vs statement_timeout

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Autovacuum vs statement_timeout
Date: 2007-03-30 04:15:28
Message-ID: 10025.1175228128@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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.
But I do not see anything in autovacuum.c that resets the variable.
Am I just being blind?  (Quite possible, as I'm tired and under the
weather.)

The thing that brought this to mind was the idea that Mark
Shuttleworth's open problem might be triggered in part by a statement
timeout interrupting autovacuum at an inopportune point --- some logs
he sent me offlist show that he is using statement_timeout ...

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: 李宁Date: 2007-03-30 05:20:26
Subject: Help: reading the source
Previous:From: Koichi SuzukiDate: 2007-03-30 04:02:52
Subject: Re: [PATCHES] Full page writes improvement, code update

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