Search Postgresql Archives

Alter index .. set tablespace uses ACCESS EXCLUSIVE lock?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: PostgreSQL general <pgsql-general@xxxxxxxxxxxxxx>
Subject: Alter index .. set tablespace uses ACCESS EXCLUSIVE lock?
From: Francisco Reyes <lists@xxxxxxxxxxxxxxxx>
Date: Thu, 11 Feb 2010 18:30:40 -0500

The alter index page does not show the lock mode, but it seems it is anACCESS EXCLUSIVE.

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Prev by Date: Re: left join count
Next by Date: Re: Truncate and delete adds wal logs for slave to process.
Previous by thread: left join count
Next by thread: Postgres standard versus Postgres Plus Advanced Server
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux