| 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: | Whole Thread | Raw Message | 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
| 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? |