pgreplay log file replayer 1.1.0 released

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <pgsql-announce(at)postgresql(dot)org>
Subject: pgreplay log file replayer 1.1.0 released
Date: 2012-02-09 14:39:58
Message-ID: D960CB61B694CF459DCFB4B0128514C207779018@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

I announce the version 1.1.0 of pgreplay.

Project home page: http://pgreplay.projects.postgresql.org/

pgreplay reads a PostgreSQL log file (*not* a WAL file),
extracts the SQL statements and executes them in the same order
and relative time against a PostgreSQL database cluster.

If the execution of statements gets behind schedule, warning
messages are issued that indicate that the server cannot handle
the load in a timely fashion.
The idea is to replay a real-world database workload as exactly
as possible.

pgreplay is useful for performance tests, particularly in the
following situations:

* You want to compare the performance of your PostgreSQL
application on different hardware or different operating systems.
* You want to upgrade your database and want to make sure that
the new database version does not suffer from performance
regressions that affect you.

Features:
* Should compile and run on any platform that PostgreSQL supports
* Can replay the workload at different speeds
* Can parse "stderr" and "csvlog" log files
* Can save workload to replay in "replay file" for reuse
* Outputs detailed parse and execution statistics

Enjoy!

Yours,
Laurenz Albe

Browse pgsql-announce by date

  From Date Subject
Next Message Gary Carter 2012-02-09 16:50:09 Postgres Plus Advanced Server v9.1 is now generally available
Previous Message Julien Rialan 2012-02-07 23:00:56 Scalr 2.5 supports PostgreSQL