Re: [PATCHES] pg_freespacemap question - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PATCHES] pg_freespacemap question
Date
Msg-id 4414E728.6080103@familyhealth.com.au
Whole thread Raw
In response to Re: [PATCHES] pg_freespacemap question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] pg_freespacemap question
List pgsql-hackers
> The point here is that if tuples require 50 bytes, and there are 20
> bytes free on a page, pgstattuple counts 20 free bytes while FSM
> ignores the page.  Recording that space in the FSM will not improve
> matters, it'll just risk pushing out FSM records for pages that do
> have useful amounts of free space.


Maybe an overloaded pgstattuple function that allows you to request FSM
behavior?

Chris


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] pg_freespacemap question
Next
From: Mark Kirkwood
Date:
Subject: Re: [PATCHES] pg_freespacemap question