Re: autovacuum and immediate shutdown issues

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: "pgsql-general(at)postgresql(dot)org mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: autovacuum and immediate shutdown issues
Date: 2009-10-19 18:35:31
Message-ID: DBEFD8C0-8EEA-42D3-B07B-058FD84DB91D@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)thebuild(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2009-10-19 18:52:47 Re: autovacuum and immediate shutdown issues
Previous Message Scott Marlowe 2009-10-19 18:26:26 Re: autovacuum and immediate shutdown issues