Re: [HACKERS] Last chance to object to MVCC-safe CLUSTER

2007-04-12 Thread Csaba Nagy 
On Sat, 2007-04-07 at 18:09, Tom Lane wrote:
 Awhile back Csaba Nagy [EMAIL PROTECTED] 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?

That workaround should actually work. It is more work but the desired
goal is achieved.

Cheers,
Csaba.



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[HACKERS] Last chance to object to MVCC-safe CLUSTER

2007-04-07 Thread Tom Lane 
Awhile back Csaba Nagy [EMAIL PROTECTED] 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.)

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] Last chance to object to MVCC-safe CLUSTER

2007-04-07 Thread Bruce Momjian 
Tom Lane wrote:
 Awhile back Csaba Nagy [EMAIL PROTECTED] 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  [EMAIL PROTECTED]  http://momjian.us
  EnterpriseDB   http://www.enterprisedb.com

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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings