Re: COPY write load on primary impacting replica?

Поиск
Список
Период
Сортировка
От Licio Matos
Тема Re: COPY write load on primary impacting replica?
Дата
Msg-id CAK6Tc4P0rhq+bcVVa_USwC9AUQM39HGiaQuO55QWP5jJMSbNbg@mail.gmail.com
обсуждение исходный текст
Ответ на COPY write load on primary impacting replica?  (Wells Oliver <wells.oliver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: COPY write load on primary impacting replica?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: COPY write load on primary impacting replica?