Re: pgbench vs. SERIALIZABLE - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: pgbench vs. SERIALIZABLE
Date
Msg-id 519817FB.2010800@joh.to
Whole thread Raw
In response to Re: pgbench vs. SERIALIZABLE  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: pgbench vs. SERIALIZABLE  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
On 2013-05-19 00:03, Fabien COELHO wrote:
>> My thinking is that what pgbench should do is:
>> * track an error count
>> * if it finds an error, don't increment the transaction count, but do
>> increment the error count.
>> * then continue to the next transaction.
>>
>> Does that seem like the right approach?
>
> Should it give up trying under some conditions, say there are more errors
> than transactions?

I don't really see the point of that.  I can't think of a scenario where 
you would get too many serialization errors to even finish the pgbench test.

At any rate, as proposed, this would fail horribly if the very first 
transaction fails, or the second transaction fails twice, etc..


Regards,
Marko Tiikkaja



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench vs. SERIALIZABLE
Next
From: David Fetter
Date:
Subject: Re: request a new feature in fuzzystrmatch