Re: Fwd: [GENERAL] Streaming replication bandwith per table

2017-07-05 Thread Maeldron T.
Thank you. Maybe it would help, but recently I had another issue with the tables having large arrays. I likely will redesign that part of the application, and I’ll see if it helps as a side effect. On Thu, Jun 22, 2017 at 5:55 AM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > O

Re: Fwd: [GENERAL] Streaming replication bandwith per table

2017-06-21 Thread Peter Eisentraut
On 6/21/17 22:04, Maeldron T. wrote: > * Logical replication is in 10.0 Beta 1. I might be oldschool but I > would install 10.1 or maybe 10.0.2 into production There are also other logical replication options such as pglogical and londiste. -- Peter Eisentraut http://www.2ndQuadrant

Fwd: [GENERAL] Streaming replication bandwith per table

2017-06-21 Thread Maeldron T.
On Tue, Jun 20, 2017 at 3:06 AM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> 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. > I could do a lot. For example, if I

Re: [GENERAL] Streaming replication bandwith per table

2017-06-19 Thread Andreas Kretschmer
Am 20. Juni 2017 03:06:05 MESZ schrieb Peter Eisentraut : >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

Re: [GENERAL] Streaming replication bandwith per table

2017-06-19 Thread Peter Eisentraut
On 6/19/17 20:50, Maeldron T. wrote: > Streaming replication generates too much traffic to set it up between > different regions for financial reasons. The streaming replication would > cost more than every other hosting expense altogether (including every > the traffic, even though it’s web and hu

[GENERAL] Streaming replication bandwith per table

2017-06-19 Thread Maeldron T.
Hello, tl;dr Streaming replication generates too much traffic to set it up between different regions for financial reasons. The streaming replication would cost more than every other hosting expense altogether (including every the traffic, even though it’s web and huge amount of emails). Is ther