Re: Autovacuum and OldestXmin - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Autovacuum and OldestXmin
Date
Msg-id 1195757518.4246.255.camel@ebony.site
Whole thread Raw
In response to Re: Autovacuum and OldestXmin  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
On Thu, 2007-11-22 at 15:20 -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
> > I notice that slony records the oldestxmin that was running when it last
> > ran a VACUUM on its tables. This allows slony to avoid running a VACUUM
> > when it would be clearly pointless to do so.
> > 
> > AFAICS autovacuum does not do this, or did I miss that?
> 
> Hmm, I think it's just because nobody suggested it and I didn't came up
> with the idea.

OK, well, me neither :-(

...and I never thought to look at slony before now.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Autovacuum and OldestXmin
Next
From: Heikki Linnakangas
Date:
Subject: Re: Autovacuum and OldestXmin