Hi, On 12 December 2011 15:39, Jayadevan M <Jayadevan.Maymala@xxxxxxxxxx> 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@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
