Postgres Pro
Downloads
Home   >   mailing lists

Re: regression, deadlock in high frequency single-row UPDATE - Mailing list pgsql-bugs

From Andrew Sackville-West
Subject Re: regression, deadlock in high frequency single-row UPDATE
Date
Msg-id CAAdHSJk7E5oNuinLwqTzmqGKRHaMmGa5KwBf9BWAmiNfLyHSgw@mail.gmail.com
Whole thread Raw
In response to Re: regression, deadlock in high frequency single-row UPDATE  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: regression, deadlock in high frequency single-row UPDATE
List pgsql-bugs
Tree view 
On Mon, Dec 8, 2014 at 9:58 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz
> wrote:

> On 09/12/14 12:55, Andrew Sackville-West wrote:
>
>>
>> https://gist.github.com/andrewsw-janrain/40d1687db013b1e7c3b3
>>
>> for detailed instructions on how to trigger the deadlock.
>
>

>
>>
> That is interesting - FWIW I can reproduce:
>
> - 9.2.9 no deadlock
> - 9.4rc1 many deadlocks
>
> so something has changed after 9.2 for sure!
>
> Just mucking about I changed certain things in your schema setup (removed
> ON DELETE CASCADE, use CURRENT_TIMESTAMP instead of now()...lessen the use
> of DEFAULT)...however still seeing deadlocks in 9.4, so at least it is easy
> to reproduce!
>

Can you speak to what benefits those changes might yield? Or point to
relevant docs?

thanks

A


>
> Regards
>
> Mark
>
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #11986: psql uses pager inside Emacs shell buffer (not a terminal)
Next
From: Andrew Sackville-West
Date:
Subject: Re: regression, deadlock in high frequency single-row UPDATE