Re: Pre-allocated free space for row updating
От | Simon Riggs |
---|---|
Тема | Re: Pre-allocated free space for row updating |
Дата | |
Msg-id | 1125470473.4010.447.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Pre-allocated free space for row updating (like PCTFREE) (Satoshi Nagayasu <nagayasus@nttdata.co.jp>) |
Ответы |
Re: Pre-allocated free space for row updating (like PCTFREE)
|
Список | pgsql-hackers |
On Wed, 2005-08-31 at 08:32 +0900, Satoshi Nagayasu wrote: > Simon Riggs wrote: > > The summary was: > > > > 1. Have a PCTFREE column added on a table by table basis > > I think a good place to keep PCTFREE value is a new column > in the pg_class, and ALTER TABLE should be able to change this value. Agreed > > 2. Apply PCTFREE for Inserts only > > 3. Allow Updates to use the full space in the block. > > 4. Allow to repair fragmentation in each page. > > Because updates cause fragmentation in the page. > > So we need to keep large continuous free space in each page, > if we want to get more effective on PCTFREE feature. ...doesn't VACUUM already do that? Anyway, if the setting is for each specific table then the performance benefit is very clear. Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления: