Hi,
On 12 December 2011 15:39, Jayadevan M <Jayadevan.Maymala@ibsplc.com> wrote:
> At the db level, Oracle provides "Database replay" feature. that lets you
> replay the production server events in the development/test environment.
> http://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_intro.htm
> Won't something like this be useful in PostgreSQL? It will let us mimic the
> production environment load and analyze it better.
There is project called pgreplay (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. The idea is to replay a
real-world database workload as exactly as possible.
--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)