Re: PostgreSQL and Real Application Testing (RAT)
| От | Jaime Casanova |
|---|---|
| Тема | Re: PostgreSQL and Real Application Testing (RAT) |
| Дата | |
| Msg-id | CAJGNTePUxUW9Nq0mX2Cnuju98TMFe2QsH3NYHGSpqYi6NWGVFA@mail.gmail.com обсуждение исходный текст |
| Ответ на | PostgreSQL and Real Application Testing (RAT) (ROS Didier <didier.ros@edf.fr>) |
| Список | pgsql-hackers |
On Tue, 27 Aug 2019 at 05:47, ROS Didier <didier.ros@edf.fr> wrote:
Hi
In my business, one of the things blocking the migration from Oracle to PostgreSQL is not having the equivalent of Oracle Real Application Testing .
This product captures a charge in production and replay it in a test environment.
this allows to know the impacts of a migration to a newer version, the creation of an index..
is there an equivalent in the PostgreSQL community?
I used https://github.com/laurenz/pgreplay recently to re-execute the queries sent to a pg9.1 in a pg11. It was very useful to find queries that are affected but changes in default values of GUCs.
Normally, a query that works in an old version will work in a new one; but this is useful to catch the few that don't if any
Jaime Casanova www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: