Re: Autovacuum Improvements - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Autovacuum Improvements
Date
Msg-id 200612192157.kBJLvOg15149@momjian.us
Whole thread Raw
In response to Re: Autovacuum Improvements  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera wrote:
> Chris Browne wrote:
> > matthew@zeut.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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: admin82.sql
Next
From: Glen Parker
Date:
Subject: Re: Autovacuum Improvements