Re: [GENERAL] Streaming replication bandwith per table - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] Streaming replication bandwith per table
Date
Msg-id 37319C97-69E9-4F35-AADF-B7E37142DA30@a-kretschmer.de
Whole thread Raw
In response to Re: [GENERAL] Streaming replication bandwith per table  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List 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 by date:

Previous
From: Computer Study
Date:
Subject: Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED