CLUSTER locking
Hi,
Is there a way the CLUSTER command can be changed to not take an
exclusive lock on the table, and instead allow reads on the old table
and index, just preventing writes?
Chris
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
No. Committing the relfilenode swap would cut the knees off of any
active scan on the old file.
Could it upgrade its lock to exclusive just before doing the swap?
Chris
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
No. Committing the relfilenode swap would cut the knees off of any
active scan on the old file.
Could it upgrade its lock to exclusive just before doing the swap?
That is a recipe for deadlock failures.
regards, tom lane