Re: Autovacuum Improvements

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Chris Browne <cbbrowne@acm.org>, pgsql-general@postgresql.org
Date: 2006-12-19T21:57:24Z
Lists: pgsql-hackers
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. +