Re: Postgresql backend to perform vacuum automatically - Mailing list pgsql-hackers

From mlw
Subject Re: Postgresql backend to perform vacuum automatically
Date
Msg-id 3C851AB2.1621AC3F@mohawksoft.com
Whole thread Raw
In response to Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: Database Caching
Next
From: Bruce Momjian
Date:
Subject: Re: Postgresql backend to perform vacuum automatically