Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER locking - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CLUSTER locking
Date
Msg-id 14688.1084189592@sss.pgh.pa.us
Whole thread Raw
In response to CLUSTER locking  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: CLUSTER locking  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Is there a way the CLUSTER command can be changed to not take an 
> exclusive lock on the table,

No.  Committing the relfilenode swap would cut the knees off of any
active scan on the old file.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: CLUSTER locking
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Comments on all system objects