470,614 Members | 1,396 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Record locking in deadlock

I have an application that uses Postgres 7.2.3. It appears to deadlock fromtime to time. I'm not absolutely sure that it deadlocks, but I'm pretty sure because all of a sudden all my updates block, and my postgres processes are all idle.

The strange thing is that my application never concurrently modifies any row (although it does modify multiple rows in the same table within a given transaction), so I don't know how this could happen, unless perhaps locking occurs on pages rather than rows. Can someone explain to me how/why my application could be deadlocking?

Thanks in advance.

Robert Wille

Nov 11 '05 #1
0 2318

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Puvendran | last post: by
9 posts views Thread by john smile | last post: by
3 posts views Thread by heynothanks | last post: by
5 posts views Thread by chintalas | last post: by
1 post views Thread by Ferdinand Zaubzer | last post: by
1 post views Thread by Syn | last post: by
3 posts views Thread by interz12 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.