| From: | Jakub Olczyk <jwo(at)disroot(dot)org> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: benchmarking proposed config |
| Date: | 2020-02-21 09:55:14 |
| Message-ID: | 20200221105514.084cb730@el-t490 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Scott,
On Thu, 20 Feb 2020 09:12:09 -0700
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?
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2020-02-21 14:53:54 | Re: benchmarking proposed config |
| Previous Message | Scott Ribe | 2020-02-20 16:12:09 | benchmarking proposed config |