Hannu Krosing <hannu(at)tm(dot)ee> writes:
> I have been pondering if keeping pages half-empty (or even 70% empty)
> could solve both clustering problems and longish updates for much data.
You could achieve that pretty easily if you simply don't ever VACUUM
UPDATE has always (AFAIR) attempted to place the new version on the same
page as the old, moving it elsewhere only if it doesn't fit. So that
part of the logic is already there.
> So "VACUUM FULL 65% EMPTY;" could make sense ?
Not so much that, as a parameter to CLUSTER telling it to fill pages
only x% full.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Cecilia Alvarez||Date: 2003-04-25 22:33:13|
|Subject: Indexes with different datatypes|
|Previous:||From: Jan Wieck||Date: 2003-04-25 19:52:16|
|Subject: Re: [PERFORM] Foreign key performance|