Re: CLUSTER locking

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CLUSTER locking
Date: 2004-05-10 11:46:32
Message-ID: 14688.1084189592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2004-05-10 12:07:41 Re: Comments on all system objects
Previous Message Wolfgang Reichart 2004-05-10 11:17:57 SPI and bytea columns