Postgres Pro
Downloads
Home   >   mailing lists

Alter index .. set tablespace uses ACCESS EXCLUSIVE lock? - Mailing list pgsql-general

From Francisco Reyes
Subject Alter index .. set tablespace uses ACCESS EXCLUSIVE lock?
Date
Msg-id cone.1265931040.585490.24981.1000@shelca
Whole thread Raw
List pgsql-general
Tree view 
The alter index page does not show the lock mode, but it seems it is an
ACCESS EXCLUSIVE.

Wouldn't an EXCLUSIVE lock be more appropriate and remove the index from
planner consideration?

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: left join count
Next
From: Alvaro Herrera
Date:
Subject: Re: Truncate and delete adds wal logs for slave to process.