| From: | Greg Smith <greg(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com> |
| Cc: | Satoshi Nagayasu <satoshi(dot)nagayasu(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-general-owner(at)postgresql(dot)org |
| Subject: | Re: Hope for a new PostgreSQL era? |
| Date: | 2011-12-12 11:43:27 |
| Message-ID: | 4EE5E8DF.4080104@2ndQuadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2011-12-12 12:10:05 | Re: Hope for a new PostgreSQL era? |
| Previous Message | Cédric Villemain | 2011-12-12 07:58:51 | Re: Howto to clear PostgreSQL cache and how to preload all tuples of a table into the cache? |