Simon Riggs wrote:
>>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?
VACUUM generates a huge load because it repaires all pages
on the table file.
I think (more light-weight) repairing on a single page
is needed to maintain free space in the specific page.
--
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>
