| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposed patch: Smooth replication during VACUUM FULL |
| Date: | 2011-05-02 17:05:15 |
| Message-ID: | BANLkTim9XMN=U-8NRp9TYDbhrz3m-qd2ug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, May 2, 2011 at 5:20 PM, Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Bartolini | 2011-05-02 17:15:11 | Re: Proposed patch: Smooth replication during VACUUM FULL |
| Previous Message | Dickson S. Guedes | 2011-05-02 16:57:38 | Re: PostgreSQL 9.1 beta1 disponível para testes. |