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 <ronljohnso...@gmail.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. >
