Re: Clustering with minimal locking

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clustering with minimal locking
Date: 2008-06-17 16:37:24
Message-ID: C47D4464.9AE19%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> BOOM! Deadlock.

No more likely than with the current cluster command. Acquiring the lock is
the same risk; but it is held for much less time.

> ...I think what makes a lot
> more sense is to have a form of clustering that puts effort into
> placing tuples in the correct location.

Agreed that would be more desirable; thought it might be more difficult.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-06-17 16:50:17 Re: inserting to a multi-table view
Previous Message Cyril SCETBON 2008-06-17 15:52:51 Re: Error when trying to drop a tablespace