On 12/11/2011 11:39 PM, Jayadevan M 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 are several projects aiming at this goal in various ways:
http://wiki.postgresql.org/wiki/Statement_Playback
Some of the features currently under development right now will make
this sort of thing easier to build into the core database. For example,
the recent "Command Triggers" feature submission will make it easier to
catch DDL changes as well as queries for this sort of thing.
--
Greg Smith 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us