Horton

Re: First steps with 8.3 and autovacuum launcher

Michael Paesold <mpaesold@gmx.at>

View thread View on postgr.es
From: Michael Paesold <mpaesold@gmx.at>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Heikki Linnakangas <heikki@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, Gregory Stark <stark@enterprisedb.com>, Guillaume Smet <guillaume.smet@gmail.com>, "Matthew T. O'Connor" <matthew@zeut.net>, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2007-10-12T09:08:21Z
Lists: pgsql-hackers 
Simon Riggs wrote:
> I think the best way to handle this is to have two limits.
> 
> First limit attempts to autovacuum, but can be cancelled.
> 
> When we hit second limit, sometime later, then autovacuum cannot be
> cancelled.
> 
> That would give us a breathing space if we need it.

Sounds quite reasonable.

Best Regards
Michael Paesold