Re: Proposed patch: Smooth replication during VACUUM FULL - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Proposed patch: Smooth replication during VACUUM FULL
Date
Msg-id BANLkTim9XMN=U-8NRp9TYDbhrz3m-qd2ug@mail.gmail.com
Whole thread Raw
In response to Re: Proposed patch: Smooth replication during VACUUM FULL  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Mon, May 2, 2011 at 5:20 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Yeah, it would help during the initial scan
>> of the old rel, but not during the sort or reindex steps.
>
> As Greg points out, the sort is not really of concern (for now).

Though I was surprised the reindex isn't an equally big problem. It
might matter a lot what the shape of the schema is. If you have lots
of indexes the index wal might be larger than the table rebuild.

-- 
greg


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Copy/paste from psql - was: Changing the continuation-line prompt in psql?
Next
From: Gabriele Bartolini
Date:
Subject: Re: Proposed patch: Smooth replication during VACUUM FULL