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