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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
