View Single Post

   
  #6 (permalink)  
Old 04-15-2008, 11:34 PM
Simon Riggs
 
Posts: n/a
Default Re: Autovacuum and OldestXmin

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote