CLUSTER uses an ACCESS EXCLUSIVE lock. Why does it forbid concurrent reads?
Florian G. Pflug, on a post (
suggested that there were no way to let the old entry until the command
I would like Cluster to create a new table, copying old values to this
one, then delete the old one. This would allow Cluster to work with a
share update exlusive lock, in order to allow reading the table while
cluster is working.
How does Cluster actually works? Why making a Cluster command less
restrictive isn't even in the TO-list?
pgsql-hackers by date
|Next:||From: Pavan Deolasee||Date: 2007-03-01 14:00:52|
|Subject: HOT WIP Patch - version 4.0|
|Previous:||From: Zeugswetter Andreas ADI SD||Date: 2007-03-01 13:52:16|
|Subject: Re: Resumable vacuum proposal and design overview|