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

From Licio Matos
Subject Re: COPY write load on primary impacting replica?
Date
Msg-id CAK6Tc4P0rhq+bcVVa_USwC9AUQM39HGiaQuO55QWP5jJMSbNbg@mail.gmail.com
Whole thread Raw
In response to COPY write load on primary impacting replica?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Why not make the COPY in small batch and intervals of seconds between them?!
Like COPY 10000 and wait 60 seconds for another batch.

On Wed, 19 Jan 2022 at 22:28 Wells Oliver <wells.oliver@gmail.com> wrote:
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!


--
--
Licio Matos

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: COPY write load on primary impacting replica?
Next
From: Laurenz Albe
Date:
Subject: Re: COPY write load on primary impacting replica?