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 по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Automatic free space map filling
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: Problemas with gram.y