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 Sup
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 fo
On Sun, Jul 21, 2013 at 9:15 PM, Pavel Stehule 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
It still behaves
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" napsal(a):
>
> I wish
I wish one of the PG developers would respond to this...
On Mon, Jul 8, 2013 at 9:54 AM, pg noob 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 deadlock (with
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, Mosh
Also on 9.3 beta2.
On Thu, Jul 4, 2013 at 5:40 AM, Moshe Jacobson wrote:
> Confirmed reproducible on version 9.1 as well. Very odd.
>
>
> On Wed, Jul 3, 2013 at 1:30 PM, pg noob wrote:
>
>>
>> Hi all,
>>
>> I am trying to understand some odd locking behaviour.
>> I apologize in advance if this
Confirmed reproducible on version 9.1 as well. Very odd.
On Wed, Jul 3, 2013 at 1:30 PM, pg noob 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 described in
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 purp
