Re: Vacuum summary? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Vacuum summary?
Date
Msg-id 1121243393.3970.122.camel@localhost.localdomain
Whole thread Raw
In response to Re: Vacuum summary?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Vacuum summary?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Tue, 2005-07-12 at 14:56 -0700, Joshua D. Drake wrote:
> > It'd be relatively easy I think to extract the current FSM statistics
> > in a function that could be invoked separately from VACUUM.  Not sure
> > how we ought to return 'em though --- the VACUUM way of a bunch of INFO
> > messages is a bit old-fashioned.  Maybe a statistics view?
> 
> That would work for me.

Sounds good.

I would also like the statistics view to show when all the FSM tracked
pages are used up for a particular relation and the relation needs
vacuuming. That way we can integrate it with autovacuum.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Order by optimisations?
Next
From: Simon Riggs
Date:
Subject: A Guide to Constraint Exclusion (Partitioning)