Am 20. Juni 2017 03:06:05 MESZ schrieb Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxx>: >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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
