Re: regression, deadlock in high frequency single-row UPDATE

Поиск
Список
Период
Сортировка
От Andrew Sackville-West
Тема Re: regression, deadlock in high frequency single-row UPDATE
Дата
Msg-id 20141215200640.GJ5679@andrew-ThinkPad-X230
обсуждение исходный текст
Ответ на Re: regression, deadlock in high frequency single-row UPDATE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
On Fri, Dec 12, 2014 at 06:57:52PM -0300, Alvaro Herrera wrote:
> Alvaro Herrera wrote:
> > Alvaro Herrera wrote:
> >
> > > I'm going to experiment with that idea and see if it leads to a
> > > solution.  I tried the other idea yesterday (to keep the HW tuple lock
> > > we acquire in heap_lock_tuple until heap_update is done) but aside from
> > > being very complicated and bug-prone, it doesn't solve the problem
> > > anyway.
> >
> > Here's a preliminary patch.
>
> Here's a finished version of this patch, which I messed a bit with and
> so needs some extra testing.  I want to push this shortly and backpatch
> to 9.4 and 9.3.  I don't want to disrupt the 9.4.0 release next week,
> but it'd be nice not to ship it with this bug.

We have tested this patch on the latest postgresql with our actual
application and it appears to work for us.

We'll be happy to test a patch against the 9.3 series, using our actual
application, as well when it becomes available.

thanks!

A

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12228: Primary use-case of PERCENT_RANK not supported
Следующее
От: omkar1103@gmail.com
Дата:
Сообщение: BUG #12242: No error - if there is no comma seperator