Re: Error on pgbench logs
Fabien COELHO <coelho@cri.ensmp.fr>
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Michael Paquier <michael@paquier.xyz>
Cc: Yugo NAGATA <nagata@sraoss.co.jp>,
Kyotaro Horiguchi <horikyota.ntt@gmail.com>, rulyox@gmail.com,
PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-06-16T06:58:17Z
Lists: pgsql-hackers
Attachments
- pgbench-log-fix-4.patch (text/x-diff) patch
Michaël-san, Yugo-san, >> I am fine with this version, but I think it would be better if we have >> a comment explaining what "tx" is for. Yes. Done. >> Also, how about adding Assert(tx) instead of using "else if (tx)" because >> we are assuming that tx is always true when agg_interval is not used, right? Ok. Done. > Agreed on both points. From what I get, this code could be clarified > much more, I agree that the code is a little bit awkward. > and perhaps partially refactored to have less spaghetti > code between the point where we call it at the end of a thread or when > gathering stats of a transaction mid-run, but that's not something to > do post-beta1. Yep. > I am not completely sure that the result would be worth it either. I'm not either. > Let's document things and let's the readers know better the > assumptions this area of the code relies on, for clarity. Sure. > The dependency between agg_interval and sample_rate is one of those > things, somebody needs now to look at the option parsing why only one is > possible at the time. Actually it would work if both are mixed: the code would aggregate a sample. However it does not look very useful to do that, so it is arbitrary forbidden. Not sure whether this is that useful to prevent this use case. > Using an extra tx flag to track what to do after the loop for the > aggregate print to the log file is an improvement in this direction. Yep. Attached v4 improves comments and moves tx as an assert. -- Fabien.
Commits
-
Fix pgbench timestamp bugs.
- 5614a0f78eaa 14.0 landed
- 0e39a608ed55 15.0 landed
-
pgbench: Improve time logic.
- 547f04e7348b 14.0 cited
-
Make [U]INT64CONST safe for use in #if conditions.
- 9d6b160d7db7 11.0 cited
-
Teach libpq to detect integer overflow in the row count of a PGresult.
- 2e70d6b5e99b 11.0 cited