Re: Clustering with minimal locking

[Decibel! <decibel@xxxxxxxxxxx>]

On Jun 17, 2008, at 11:37 AM, Scott Ribe wrote:
> > 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.


Actually, no (at least in 8.2). CLUSTER grabs an exclusive lock  
before it does any work meaning that it can't deadlock by itself. Of  
course you could always do something like

BEGIN;
SELECT * FROM a;
CLUSTER .. ON a;
COMMIT;

Which does introduce the risk of a deadlock, but that's your fault,  
not Postgres.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828

<<attachment: smime.p7s>>