Re: Last chance to object to MVCC-safe CLUSTER

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Last chance to object to MVCC-safe CLUSTER
Date: 2007-04-07 16:11:51
Message-ID: 200704071611.l37GBp803440@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Awhile back Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
> > Making cluster MVCC-safe will kill my back-door of clustering a hot
> > table while I run a full DB backup.
>
> Are we agreed that the TRUNCATE-based workaround shown here
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00606.php
> is an adequate response to this objection?
>
> (This assumes of course that TRUNCATE will never become MVCC-safe,
> but I think that's a reasonable thing to assume. I notice we don't
> document TRUNCATE as unsafe ... will go fix that.)

Yes, I agree on all points.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ottó Havasvölgyi 2007-04-07 16:45:42 Re: Eliminating unnecessary left joins
Previous Message Michael Fuhr 2007-04-07 16:10:08 Re: Fate of pgsnmpd