Postgres Pro
Downloads
Home   >   mailing lists

Re: concurrent SELECT blocking ALTER? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: concurrent SELECT blocking ALTER?
Date
Msg-id lcc0jn$ve2$1@ger.gmane.org
Whole thread Raw
In response to Re: concurrent SELECT blocking ALTER?  (Neil Harkins <nharkins@gmail.com>)
Responses Re: concurrent SELECT blocking ALTER?  (Neil Harkins <nharkins@gmail.com>)
List pgsql-general
Tree view 
Neil Harkins wrote on 29.01.2014 23:37:
> I totally understand DDL taking exclusive locks, the problem here seems to be that the *SELECTs*
>are taking out exclusive locks, locking out the ALTER, which feels like a bug.

The SELECT is not holding an exclusive lock, it's holing a *shared* lock, but the ALTER is _requesting_ an exclusive
lockand that can only be granted until all shared (or otherwise incompatible) locks are released.

pgsql-general by date:

Previous
From: Neil Harkins
Date:
Subject: Re: concurrent SELECT blocking ALTER?
Next
From: Neil Harkins
Date:
Subject: Re: concurrent SELECT blocking ALTER?