pgbench transaction timestamps

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: pgbench transaction timestamps
Date: 2007-04-01 01:30:34
Message-ID: Pine.GSO.4.64.0703312102230.20877@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

This patch changes the way pgbench outputs its latency log files so that
every transaction gets a timestamp and notes which transaction type was
executed. It's a one-line change that just dumps some additional
information that was already sitting in that area of code. I also made a
couple of documentation corrections and clarifications on some of the more
confusing features of pgbench.

It's straightforward to parse log files in this format to analyze what
happened during the test at a higher level than was possible with the
original format. You can find some rough sample code to convert this
latency format into CVS files and then into graphs at
http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm which I'll
be expanding on once I get all my little patches sent in here.

If you recall the earlier version of this patch I submitted, it added a
cleanup feature that did a vacuum and checkpoint after the test was
finished and reported two TPS results. The idea was to quantify how much
of a hit the eventual table maintenance required to clean up after the
test would take. While those things do influence results and cause some
of the run-to-run variation in TPS (checkpoints are particularly visible
in the graphs), after further testing I concluded running a VACUUM VERBOSE
and CHECKPOINT in a script afterwards and analyzing the results was more
useful than integrating something into pgbench itself.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

Attachment Content-Type Size
pgbench-timestamp.txt text/plain 3.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-04-01 02:31:26 Re: Macros for typtype (was Re: Arrays of Complex Types)
Previous Message Peter Eisentraut 2007-04-01 00:28:54 Re: Macros for typtype (was Re: Arrays of Complex Types)

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-01 02:12:45 Re: Current enums patch
Previous Message Tom Dunstan 2007-04-01 01:05:48 Re: Current enums patch