Re: WIP Patch: Pgbench Serialization and deadlock errors

From: Marina Polyakova <m(dot)polyakova(at)postgrespro(dot)ru>
To: Kevin Grittner <kgrittn(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, " pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Subject: Re: WIP Patch: Pgbench Serialization and deadlock errors
Date: 2017-06-17 08:39:02
Message-ID: 44ebd013-8f23-4a00-85fb-255f871d5b14@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<div dir='auto'><div class="gmail_extra" dir="auto"><div style="font-family: sans-serif; font-size: 13.696px;" dir="auto"><div style="font-size: 13.696px;" dir="auto"><div><font face="arial, helvetica, sans-serif">&gt; To be clear, part of "retrying from the beginning" means that if a</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">result from one statement is used to determine the content (or</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">whether to run) a subsequent statement, that first statement must be</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">run in the new transaction and the results evaluated again to</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">determine what to use for the later statement.&nbsp; You can't simply</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">replay the statements that were run during the first try.&nbsp; For</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif">examples, to help get a feel of why that is, see:</font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;&nbsp;</span><font face="arial, helvetica, sans-serif"><br></font></div><div><span style="font-family:'arial' , 'helvetica' , sans-serif">&gt;</span><span style="font-family:'arial' , 'helvetica' , sans-serif">&nbsp;</span><font face="arial, helvetica, sans-serif"><a href="https://wiki.postgresql.org/wiki/SSI" style="text-decoration-line: none; color: rgb(66, 133, 244);">https://wiki.postgresql.org/<wbr>wiki/SSI</a></font></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">Thank you again! :))</font></div></div><div style="font-size: 13.696px; font-family: arial, helvetica, sans-serif;" dir="auto"><br></div><div style="font-size: 13.696px; font-family: arial, helvetica, sans-serif;" dir="auto">--&nbsp;</div><div style="font-size: 13.696px; font-family: arial, helvetica, sans-serif;" dir="auto">Marina Polyakova</div><div style="font-size: 13.696px; font-family: arial, helvetica, sans-serif;" dir="auto">Postgres Professional:&nbsp;<a href="http://www.postgrespro.com/" style="text-decoration-line: none; color: rgb(66, 133, 244);">http://www.postgrespro.com</a></div><div style="font-size: 13.696px; font-family: arial, helvetica, sans-serif;" dir="auto">The Russian Postgres Company</div></div></div></div>

Attachment Content-Type Size
unknown_filename text/html 3.2 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2017-06-17 09:00:10 Typo in planstats.sgml
Previous Message Magnus Hagander 2017-06-17 08:20:21 Re: Incorrect comment in 001_ssltests.pl