Re: Dead Space Map for vacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Dead Space Map for vacuum
Date
Msg-id 17760.1167428471@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dead Space Map for vacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: Dead Space Map for vacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> On Fri, 2006-12-29 at 10:49 -0500, Tom Lane wrote:
>> Counterexample: table in which all tuples exceed half a page.

> Current FSM code will ignore those too, if they are less than the
> average size of the tuple so far requested. Thats a pretty wierd
> counterexample, even if it is a case that needs handling.

Better read it again.  The number that's passed to the FSM is the
free space *after* vacuuming, which in this scenario will be
BLCKSZ-less-page-header.  This case is not broken now, but it will
be if we adopt your proposal.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Windows installer and dlls
Next
From: Tom Lane
Date:
Subject: Re: Load distributed checkpoint