Re: Postgresql backend to perform vacuum automatically

> > > 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.
> 
> Assuming that the statistics get updated:
> 
> How often should the sats table be queried?
> What sort of configurability would be needed?

You could wake up every few minutes and see how the values have changed.
I don't remember if there is a way to clear that stats so you can see
just the changes in the past five minutes.  Vacuum the table that had
activity.

--  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