Re: Autovacuum Improvements

Alvaro Herrera wrote:
> Chris Browne wrote:
> > matthew(at)zeut(dot)net ("Matthew O'Connor") writes:
> >
> > > Bruce Momjian wrote:
> > >> Yes, I think there are these TODO items. I was waiting to see what
> > >> additional replies there are before adding them.
> > >
> > > Speaking of which, I was just looking at the TODO at:
> > >
> > > http://www.postgresql.org/docs/faqs.TODO.html
> > >
> > > and I think this item:
> > >
> > > * Improve xid wraparound detection by recording per-table rather than
> > > per-database
> > >
> > > is done and working in 8.2 no?
> >
> > That's in the 8.2 release notes:
> >
> > - Track maximum XID age within individual tables, instead of whole
> > databases (Alvaro)
> >
> > This reduces the overhead involved in preventing transaction ID
> > wraparound, by avoiding unnecessary VACUUMs.
>
> Yeah, this is what the TODO item was about, so it certainly is done.

OK, item removed. Thanks.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +