Horton
Menu

Re: [PATCHES] pg_freespacemap question

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>, markir@paradise.net.nz, alvherre@commandprompt.com, peter_e@gmx.net, pgsql-hackers@postgresql.org, pgsql-patches@postgresql.org
Date: 2006-03-13T03:29:44Z
Lists: 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