Re: patch review, please: Autovacuum/Vacuum times via stats.

On Wed, May 03, 2006 at 02:25:54PM -0400, Tom Lane wrote:
> > On Tue, May 02, 2006 at 05:49:33PM -0500, Jim C. Nasby wrote:
> >> Back in the discussion of this someone had mentioned capturing all the
> >> info that you'd get from a vacuum verbose; dead tuples, etc. What do
> >> people think about that? In particular I think it'd be handy to know how
> >> many pages vacuum wanted in the FSM vs. how many it got; this would make
> >> it much easier for people to ensure that the FSM is large enough.
> 
> Isn't this already dealt with by contrib/pg_freespacemap?

AFAIK that does nothing to tell you how much space is desired by
relations. It would tell you if the FSM is nearly full, but I'm not sure
that's very reliable, especially given how every relation that wants
space in the FSM is giving a sizeable minimum number of pages (16,
iirc). Even putting that aside, it'd be nice to have an exact amount of
space that was needed.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461