Re: benchmarking proposed config - Mailing list pgsql-admin

From bricklen
Subject Re: benchmarking proposed config
Date
Msg-id CAGrpgQ9uBr5iRR1+u04saP7kBwPFomC=yAX3wbDF5af5Lev3vw@mail.gmail.com
Whole thread Raw
In response to benchmarking proposed config  (Scott Ribe <scott_ribe@killerbytes.com>)
List pgsql-admin
On Thu, Feb 20, 2020 at 12:10 PM 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?

(We could live with the new one falling behind as long as queries were queued not lost--in fact we know this will happen.)

PgShark might work for this

pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: test
Next
From:
Date:
Subject: ZABBIX - For PostgreSQL Monitoring GUI based