COPY write load on primary impacting replica? - Mailing list pgsql-admin

From Wells Oliver
Subject COPY write load on primary impacting replica?
Date
Msg-id CAOC+FBWNoPi_Tbmc14fOtHF0j0AYcgVMO_LWT7_XAPYeZqii0w@mail.gmail.com
Whole thread Raw
Responses Re: COPY write load on primary impacting replica?
Re: COPY write load on primary impacting replica?
List pgsql-admin
Hi: I have an issue where a big big big COPY is thrashing a disk on a DB, my idea was to fire up a read replica of this DB and point my users to it for SELECT (read) operations, thereby hopefully (?) avoiding the disk usage caused by COPY on the primary.

Wondering if this is foolish, whether the WAL log stuff would cause equal disk usage on the replica.

Thanks!

--

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: effective_io_concurrency
Next
From: Licio Matos
Date:
Subject: Re: COPY write load on primary impacting replica?