| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: benchmarking proposed config |
| Date: | 2020-02-24 17:15:49 |
| Message-ID: | CAGrpgQ9uBr5iRR1+u04saP7kBwPFomC=yAX3wbDF5af5Lev3vw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Feb 20, 2020 at 12:10 PM Scott Ribe <scott_ribe(at)killerbytes(dot)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
https://github.com/dalibo/pgshark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-02-24 17:54:53 | Re: Reset DB stats suggestion pg_stat_reset() |
| Previous Message | Merlin Moncure | 2020-02-24 16:34:03 | Re: DB running out of memory issues after upgrade |