Re: Patch: Tie stats options to autovacuum in

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Patch: Tie stats options to autovacuum in
Дата
Msg-id 200610030041.k930fuo24138@momjian.us
обсуждение исходный текст
Ответ на Re: Patch: Tie stats options to autovacuum in postgresql.conf  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: Patch: Tie stats options to autovacuum in  (Jim Nasby <jim@nasby.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: TM modificator don't work? to_char
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: TM modificator don't work? to_char