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?  (Licio Matos <licio.matos@gmail.com>)
Re: COPY write load on primary impacting replica?  (Laurenz Albe <laurenz.albe@cybertec.at>)
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?