Re: Postgresql backend to perform vacuum automatically

mlw wrote:
> 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?

I think Jan said 2-3%.  If we can get autovacuum from it, it would be a
win to keep it on all the time, perhaps.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026