Re: Patch: Tie stats options to autovacuum in - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Patch: Tie stats options to autovacuum in
Date
Msg-id 200610030041.k930fuo24138@momjian.us
Whole thread Raw
In response to Re: Patch: Tie stats options to autovacuum in postgresql.conf  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Patch: Tie stats options to autovacuum in
List pgsql-hackers
David E. Wheeler wrote:
> On Sep 28, 2006, at 16:39, Jim C. Nasby wrote:
> 
> > +1. I was just at a client today that had run into this problem.
> >
> > Actually, I'm in favor of refusing to start if autovac is on but the
> > proper stats settings aren't. I'd rather that then people ending up  
> > with
> > bloated databases and crappy performance.
> 
> I agree, but I figured that this was a start, at least.

The problem with refusing to start is that autovacuum is sighup, so you
might modify postgresql.conf and do a server restart, and then the
server doesn't start.  Are people OK with that?

I did apply the postgresql.conf comment addition.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TM modificator don't work? to_char
Next
From: Bruce Momjian
Date:
Subject: Re: TM modificator don't work? to_char