Re: patch review, please: Autovacuum/Vacuum times via stats. - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: patch review, please: Autovacuum/Vacuum times via stats.
Date
Msg-id 20060504170513.GH97354@pervasive.com
Whole thread Raw
In response to Re: patch review, please: Autovacuum/Vacuum times via stats.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: patch review, please: Autovacuum/Vacuum times via stats.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pseudo-type record arguments for PL-functions
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Typo in ginxlog.c