On 09/11/2012 09:55 AM, AI Rumman wrote:
> I added the excel file for locks data.
> I was surprised to see that while I was updating a single column value
> for all records in a tables, all indexes are locked by the server.
Any ALTER TABLE command locks the whole table in ACCESS EXCLUSIVE mode,
indexes included. See the description of ACCESS EXCLUSIVE lock at
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2012-09-11 17:19:26|
|Subject: Re: Planner selects different execution plans depending on limit|
|Previous:||From: hubert depesz lubaczewski||Date: 2012-09-11 14:05:54|
|Subject: Re: add column with default value is very slow|