Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] pg_freespacemap question

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, alvherre(at)commandprompt(dot)com, peter_e(at)gmx(dot)net, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] pg_freespacemap question
Date: 2006-03-13 04:37:00
Message-ID: 4414F6EC.7010909@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Christopher Kings-Lynne wrote:
>> 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?
> 

That's a nice idea - could also do equivalently by adding an extra 
column "usable_free_space" or some such, and calculating this using FSM 
logic.

Cheers

Mark


In response to

Responses

pgsql-hackers by date

Next:From: Neil ConwayDate: 2006-03-13 04:52:12
Subject: Re: Proposal for updatable views
Previous:From: Christopher Kings-LynneDate: 2006-03-13 03:29:44
Subject: Re: [PATCHES] pg_freespacemap question

pgsql-patches by date

Next:From: Michael FuhrDate: 2006-03-13 06:24:10
Subject: Fix syntax errors in contrib uninstall scripts
Previous:From: Tom LaneDate: 2006-03-13 04:24:35
Subject: Re: fix of some issues with multi-line query editing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group