Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> On Thu, Sep 01, 2005 at 04:34:09PM +0100, Simon Riggs wrote:
>> On Wed, 2005-08-31 at 22:25 -0400, Alvaro Herrera wrote:
>>> Now, one thing of note is that you need to "compress" the page in order
>>> to actually be able to use the just-freed space. VACUUM could do that,
>>> but maybe it would be better to do it on-line -- the freezing process is
>>> going to have to write the page regardless. I wonder if with your patch
>>> the page is compressed on the same VACUUM execution that freezes the
>>> tuple?
>>
>> Only if you do a FULL, which is currently incompatible with a FREEZE.
> Well, if we are going to mess with what FREEZE is doing, we can as well
> make it compress the page.
Anyone looked at the code lately???
PageRepairFragmentation is part of any kind of vacuum. As long as you
don't reassign tuple IDs (which it doesn't) there's no impact on indexes.
regards, tom lane