Note the number of exclusive locks in my first message, it is equal to the
number of threads (20). Also, the ALTER was not running then, apologies if
that was not clear.
On Wednesday, January 29, 2014, Thomas Kellerer wrote:
> Neil Harkins wrote on 29.01.2014 23:37:
>
>> I totall
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.
On Wednesday, January 29, 2014, Peter Eisentraut wrote:
> On 1/29/14, 4:59 PM, Neil Harkins wrote:
> > Why
Hi all, I'm curious if anyone can explain or suggest some debugging to
explain some odd locking behavior I am able to reproduce on pg 9.2.1
I start a test program with 20 threads (autocommit=1), all
executing the same SELECT query with a LEFT OUTER JOIN,
1~2 per second. Then I execute an ALTER to
