Re: Improving free space usage (was: Reducing relation locking - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Improving free space usage (was: Reducing relation locking
Date
Msg-id 200603040502.k24526s29305@candle.pha.pa.us
Whole thread Raw
In response to Re: Improving free space usage (was: Reducing relation locking overhead)  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Jim C. Nasby wrote:
> At the risk of editorializing...
> 
> * Allow for tables with more than a certain percent of free space to
>   force new tuple allocation in the last few pages to come only from the
>   FSM (prefering the earliest pages), with the intention of allowing the
>   table to shrink

That seems too confusing.

> I also believe there's also a second TODO:
> 
> * Allow FSM page hand-out on tables to be influenced by the clustered
>   index. This would help maintain cluster order.

How would FSM know how to do that?  I added it with a question mark.

--  Bruce Momjian   http://candle.pha.pa.us SRA OSS, Inc.   http://www.sraoss.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Automatic free space map filling
Next
From: "Jaime Casanova"
Date:
Subject: Re: Problemas with gram.y