| From: | Paulo Tanimoto <paulo(at)janrain(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Andrew Sackville-West <awest(at)janrain(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: regression, deadlock in high frequency single-row UPDATE |
| Date: | 2014-12-29 23:25:00 |
| Message-ID: | CAAEhZ-aqvb-PYE2YL02Mg9pJHp6gjMhz9jRekpBny9J6Z116Vw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi Alvaro,
On Fri, Dec 26, 2014 at 8:56 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
>
> Pushed this patch to master, 9.4 and 9.3.
>
Thank you for porting and pushing your patch to these other branches.
Andrew, our team lead, is out this week, but I wanted to give you some
feedback as soon as possible.
I've built PostgreSQL 9.3 (git branch REL9_3_STABLE) with and without
this patch, and at least in my tests I was able to confirm that it
solves our issue. Besides testing it with our simplified pgbench
scripts, I also tested it locally with our Haskell web server, which
was how we ran into the deadlock error in the first place. In all my
tests, I consistently get the deadlock errors without the patch, and
no longer see them when the patch is applied.
Let us know if you'd like to see anything else tested on our end.
Take care,
Paulo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-12-29 23:38:30 | Re: [GENERAL] Rollback on include error in psql |
| Previous Message | David Johnston | 2014-12-29 22:55:10 | Re: Rollback on include error in psql |