On Tue, Dec 05, 2006 at 11:04:17AM -0500, Tom Lane wrote:
> Jim Nasby <decibel@decibel.org> writes:
> > AFAIK there isn't, and it would be useful to have. But FSM info alone
> > doesn't tell you the whole picture; you'd have to know that vacuum
> > couldn't find space in the FSM to store some pages. So perhaps what's
> > really needed is information about how many pages in a relation
> > couldn't be put into the FSM the last time a vacuum was run.
>
> Curiously enough, that's exactly what the FSM stats tell you now.
But only at the end of a database-wide vacuum verbose, right? Or did I
miss something?
It would be useful to be able to get that info in a system running
autovac (or anything else that means not normally vacuuming the whole
database).
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)