Re: autovacuum and immediate shutdown issues - Mailing list pgsql-general

From Christophe Pettus
Subject Re: autovacuum and immediate shutdown issues
Date
Msg-id DBEFD8C0-8EEA-42D3-B07B-058FD84DB91D@thebuild.com
Whole thread Raw
In response to Re: autovacuum and immediate shutdown issues  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: autovacuum and immediate shutdown issues
List pgsql-general
On Oct 19, 2009, at 11:26 AM, Scott Marlowe wrote:
> That could be a pretty bad worst case scenario for certain types of
> tables / usage patterns.

Given that (presumably) the database server is not failing repeatedly
without some kind of operator notification, isn't it at least somewhat
reasonable to just make "start an vacuum upon recovery from an
immediate shutdown" an operational procedure, rather than something PG
does automatically?

--
-- Christophe Pettus
    xof@thebuild.com


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: autovacuum and immediate shutdown issues
Next
From: Brad Nicholson
Date:
Subject: Re: autovacuum and immediate shutdown issues