From: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Marina Polyakova <m(dot)polyakova(at)postgrespro(dot)ru>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, Kevin Grittner <kgrittn(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Subject: | Re: WIP Patch: Pgbench Serialization and deadlock errors |
Date: | 2017-08-16 14:15:26 |
Message-ID: | CAPpHfdvQ=98yU6epP9Vuh_GFrTTO_fbs4DE+vDP7LF5eeAG49Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Aug 11, 2017 at 10:50 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> On 2017-07-21 19:32:02 +0300, Marina Polyakova wrote:
> > Here is the third version of the patch for pgbench thanks to Fabien
> Coelho
> > comments. As in the previous one, transactions with serialization and
> > deadlock failures are rolled back and retried until they end
> successfully or
> > their number of tries reaches maximum.
>
> Just had a need for this feature, and took this to a short test
> drive. So some comments:
> - it'd be useful to display a retry percentage of all transactions,
> similar to what's displayed for failed transactions.
> - it appears that we now unconditionally do not disregard a connection
> after a serialization / deadlock failure. Good. But that's useful far
> beyond just deadlocks / serialization errors, and should probably be
> exposed.
>
Yes, it would be nice to don't disregard a connection after other errors
too. However, I'm not sure if we should retry the *same* transaction on
errors beyond deadlocks / serialization errors. For example, in case of
division by zero or unique violation error it would be more natural to give
up with current transaction and continue with next one.
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-08-16 14:20:11 | Re: taking stdbool.h into use |
Previous Message | Heikki Linnakangas | 2017-08-16 13:20:28 | Re: Atomics for heap_parallelscan_nextpage() |