Re: Postgresql backend to perform vacuum automatically

Поиск
Список
Период
Сортировка
От mlw
Тема Re: Postgresql backend to perform vacuum automatically
Дата
Msg-id 3C851AB2.1621AC3F@mohawksoft.com
обсуждение исходный текст
Ответ на Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> 
> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Yes, I am seeing only zeros too.  Jan?
> >
> > Did you turn on statistics gathering?  See the Admin Guide's discussion
> > of database monitoring.
> 
> Oops, now I remember.  Those are off by default and only the query
> string is on by default.  Thanks.

This raises the question, by turning these on, does that affect database
performance?

If so, it may not be the answer for a selective vacuum.

If they do not affect performance, then why have them off?


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Steve Wolfe"
Дата:
Сообщение: Re: Database Caching
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Postgresql backend to perform vacuum automatically