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.0.0 released |
Date: | 2011-06-03 14:54:42 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C2067E8996@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
I announce the first production release of pgreplay, version 1.0.0.
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
From | Date | Subject | |
---|---|---|---|
Next Message | CS DBA | 2011-06-03 20:33:59 | Call For Papers - PG-Day Denver 2011 |
Previous Message | Pavel Golub | 2011-06-01 06:40:21 | PostgresDAC v2.6.3 is out |