Re: pgbench throttling latency limit - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench throttling latency limit
Date
Msg-id alpine.DEB.2.10.1410092128190.27407@sto
Whole thread Raw
In response to Re: pgbench throttling latency limit  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: pgbench throttling latency limit
List pgsql-hackers
> One thing bothers me with the log format. Here's an example:
>
>>  0 81 4621 0 1412881037 912698 3005
>>  0 82 6173 0 1412881037 914578 4304
>>  0 83 skipped 0 1412881037 914578 5217
>>  0 83 skipped 0 1412881037 914578 5099
>>  0 83 4722 0 1412881037 916203 3108
>>  0 84 4142 0 1412881037 918023 2333
>>  0 85 2465 0 1412881037 919759 740
>
> Note how the transaction counter is not incremented for skipped transactions.
> That's understandable, since we're not including skipped transactions in the 
> number of transactions executed, but it means that the skipped transactions 
> don't have a unique ID. That's annoying.

Indeed. As transactions were not done, it does not make much sense to 
identify them. Otherwise it should report "intended" transactions and 
"performed" transactions, which would not help clarify the matter much.

My idea of "skipped" transactions, which are not transactions as such, is 
just a health quality measurement for both the throttling process and the 
database latency, so I would really let it as it is.

> Here's a new version of the patch. I'll sleep over it before committing, but 
> I think it's fine now, except maybe for the unique ID thing.

I saw a typo in a comment: "lateny" -> "latency". Otherwise it looks ok, 
and the documentation seems indeed clearer than before.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: TAP test breakage on MacOS X
Next
From: Heikki Linnakangas
Date:
Subject: Re: Last Commitfest patches waiting review