Re: Hope for a new PostgreSQL era?

Hi,

On 12 December 2011 15:39, Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)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(dot)ivanic(at)gmail(dot)com)