Thank you Jeff and others for the responses.
One concern that I have is that even cases where there is no deadlock it is
still acquiring stronger locks than necessary. I only discovered it
because of the deadlock issue but I presume that there are many cases where
it is acquiring a lock on the
Moshe Jacobson escribió:
I wish one of the PG developers would respond to this...
Have you seen the thread in pgsql-bugs?
http://www.postgresql.org/message-id/e1uwamw-vh...@wrigleys.postgresql.org
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7
On Sun, Jul 21, 2013 at 9:15 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
hello
It can be artefact of RI implementation.
see
http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-for-key-share-and-for-no-key-update/
Try to 9.3, please, where RI uses more gently locks
I wish one of the PG developers would respond to this...
On Mon, Jul 8, 2013 at 9:54 AM, pg noob pgn...@gmail.com wrote:
Thank you for the responses. Is it a bug?
I discovered this because of a db deadlock that shows up in my application
logs.
I can probably work around it to avoid the
hello
It can be artefact of RI implementation.
see
http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-for-key-share-and-for-no-key-update/
Try to 9.3, please, where RI uses more gently locks
Regards
Pavel Stehule
Dne 21.7.2013 21:43 Moshe Jacobson mo...@neadwerx.com
Thank you for the responses. Is it a bug?
I discovered this because of a db deadlock that shows up in my application
logs.
I can probably work around it to avoid the deadlock (with some amount of
work) but I really don't understand why it behaves as it does.
On Thu, Jul 4, 2013 at 8:40 AM,
Also on 9.3 beta2.
On Thu, Jul 4, 2013 at 5:40 AM, Moshe Jacobson mo...@neadwerx.com wrote:
Confirmed reproducible on version 9.1 as well. Very odd.
On Wed, Jul 3, 2013 at 1:30 PM, pg noob pgn...@gmail.com wrote:
Hi all,
I am trying to understand some odd locking behaviour.
I
Confirmed reproducible on version 9.1 as well. Very odd.
On Wed, Jul 3, 2013 at 1:30 PM, pg noob pgn...@gmail.com wrote:
Hi all,
I am trying to understand some odd locking behaviour.
I apologize in advance if this is a basic question and should be widely
understood but
I don't see it
Hi all,
I am trying to understand some odd locking behaviour.
I apologize in advance if this is a basic question and should be widely
understood but
I don't see it described in the documentation as far as I could find.
I'm using Postgres 8.4.13
I have two tables, call them A B for example