Hi Scott,
On Thu, 20 Feb 2020 09:12:09 -0700
Scott Ribe <scott_ribe@killerbytes.com> wrote:
> Does anyone have suggestions for a utility that would easily let us
> mirror all queries to a "shadow" PG cluster, so that we can compare
> performance of our current production config against a new proposed
> config with our actual production traffic?
I am not sure if this would be an acceptable solution for you but there
is an open source utility called pgreplay[1]. Here is the description:
> 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.
This of course means that you'd need to have a fairly "chatty" log
configuration, but maybe it could work for your needs?
Cheers,
jwo
[1]: https://github.com/laurenz/pgreplay