Exclusive Locks Taken on User Tables?

From: Marc <pgsql-general(at)mbreslow(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Exclusive Locks Taken on User Tables?
Date: 2007-11-06 18:40:29
Message-ID: 809128960711061040g1acbcc7l18c6630c6a59ce86@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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-11-06 18:43:38 Re: Syntax error in a large COPY
Previous Message Marc Breslow 2007-11-06 18:38:05 Exclusive Locks Taken on User Tables?