Re: Postgresql backend to perform vacuum automatically

Neil Padgett wrote:
> On Tue, 2002-03-05 at 15:59, Bruce Momjian wrote:
> > > > > 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.
>
> Ick -- polling. The statistics process should be able to wake somebody
> up / notify the postmaster when the statistics change such that a vacuum
> is required.

Yes, that would tie that stats collector closer to auto-vacuum, but it
certainly could be done.

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