Exclusive Locks Taken on User Tables?

From: "Marc Breslow" <marc(at)mbreslow(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Exclusive Locks Taken on User Tables?
Date: 2007-11-06 18:38:05
Message-ID: 809128960711061038x50c81784odc61f2a53f6b5984@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm seeing an "EXCLUSIVE" lock being taken on a table even though the
documentation says that "This lock mode is not automatically acquired on
user tables by any PostgreSQL command."

My SQL is
UPDATE users SET online = $1 where username = $2

username is the PK on the users table.

Other locks taken by the transaction are 1 RowExclusiveLock for the users
table and 1 RowExclusiveLock on each of the 6 explict indexes on that table
and another for the implicity users_pkey index.

The result of these locks is that concurrent calls for the same statement
are being serialized because the ExclusiveLock being requested is not being
granted.

Any thoughts on why this might be happening and what I could do to resolve
it?

Thanks,
---Marc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc 2007-11-06 18:40:29 Exclusive Locks Taken on User Tables?
Previous Message Reg Me Please 2007-11-06 18:23:22 Re: Syntax error in a large COPY