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.
> 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.
--
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>