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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
