COPY write load on primary impacting replica?

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

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