Re: [GENERAL] Streaming replication bandwith per table

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [GENERAL] Streaming replication bandwith per table
Дата
Msg-id 37319C97-69E9-4F35-AADF-B7E37142DA30@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: [GENERAL] Streaming replication bandwith per table  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-general
Am 20. Juni 2017 03:06:05 MESZ schrieb Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
>On 6/19/17 20:50, Maeldron T. wrote:
>>
>
>Not easily.  You could play around with pg_xlogdump to see what's going
>on in the WAL.  But even if you figure it out, there is not much you
>can
>do about it.
>
>Try perhaps logical replication.  That would save you the bandwidth for
>updating all the indexes at least.  It might work for you.

Not only the traffic for indexes, for Vacuum too.
(and that can be a lot)

Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company


В списке pgsql-general по дате отправления:

Предыдущее
От: Computer Study
Дата:
Сообщение: Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED