Re: Improving free space usage (was: Reducing relation locking

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Improving free space usage (was: Reducing relation locking
Дата
Msg-id 200603040502.k24526s29305@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Improving free space usage (was: Reducing relation locking overhead)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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 по дате отправления: