]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix pgbench timestamp bugs.
authorThomas Munro <tmunro@postgresql.org>
Sun, 11 Jul 2021 07:50:55 +0000 (19:50 +1200)
committerThomas Munro <tmunro@postgresql.org>
Sun, 11 Jul 2021 08:08:49 +0000 (20:08 +1200)
commit5614a0f78eaaa51c07bd753ca854de238c730b84
tree5ac7ca1256ad4e58f4de5e8e01d7161fde2a9afa
parent10a07973cf72b32f32f0e05ada16c84580496d93
Fix pgbench timestamp bugs.

Commit 547f04e changed pgbench to use microsecond accounting, but
introduced a couple of logging and aggregation bugs:

1.  We print Unix epoch timestamps so that you can correlate them with
other logs, but these were inadvertently changed to use a
system-dependent reference epoch.  Compute Unix timestamps, and begin
aggregation intervals on the boundaries of whole Unix epoch seconds, as
before.

2.  The user-supplied aggregation interval needed to be scaled.

Back-patch to 14.

Author: Fabien COELHO <coelho@cri.ensmp.fr>
Author: Yugo NAGATA <nagata@sraoss.co.jp>
Author: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Reported-by: YoungHwan Joo <rulyox@gmail.com>
Reported-by: Gregory Smith <gregsmithpgsql@gmail.com>
Discussion: https://postgr.es/m/CAF7igB1r6wRfSCEAB-iZBKxkowWY6%2BdFF2jObSdd9%2BiVK%2BvHJg%40mail.gmail.com
Discussion: https://postgr.es/m/CAHLJuCW_8Vpcr0%3Dt6O_gozrg3wXXWXZXDioYJd3NhvKriqgpfQ%40mail.gmail.com
src/bin/pgbench/pgbench.c