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