Re: impact pgbench on a physical replicated stream

Using asynchronous replication. Production is running on a gaming PC at the
moment because it was to slow on a state of the art hypervisor 128 core 1TB
mem and nvme disk server rack... (where de replicated slave is running on)

I would like to know what number this gaming pc is pulling that supposedly
the server rack can't.

On Fri, Jul 28, 2023 at 4:50 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> On 7/28/23 07:20, Gert Cuykens wrote:
>
> Hi, I would like to pgbench the production postgres that is being physical
> replicated to a slave. Will I shoot myself in the foot because of the
> physical replication if I try pgbench on prodcution postgres.
>
>
> Replication or not, why are you running pgbench on a *production* server?
>
> And by "shoot myself in the foot", are you asking whether it would
> overwhelm some system or another, thereby breaking replication? If so, we
> can't answer that, since we don't know the hardware specifications, your
> current workload, and whether or not you're doing synchronous or
> asynchronous replication.
>
> --
> Born in Arizona, moved to Babylonia.
>