Re: [GENERAL] BDR, limit number of groups in a cluster - Mailing list pgsql-general

From Craig Ringer
Subject Re: [GENERAL] BDR, limit number of groups in a cluster
Date
Msg-id CAMsr+YGFDZdk=F9zq-j7RcCJ3107+_W89_HK0-fURpzTOMjORA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] BDR, limit number of groups in a cluster  (milist ujang <ujang.milist@gmail.com>)
List pgsql-general
On 11 September 2017 at 09:32, milist ujang <ujang.milist@gmail.com> wrote:
Hi all,

Based on the docs and look at the processes, it seems 1 wal sender on each node per group.

If there is scenario of consolidating many databases (say hundreds) into 1 database (in this central cluster there are hundreds wal sender), what is the limit number of groups?

It's not a use case I've paid much attention to. I expect it'll be limited by performance and memory, rather than have any firm limit.

Maybe you should look into pglogical. This seems like a weird use for BDR. 

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: milist ujang
Date:
Subject: [GENERAL] BDR, limit number of groups in a cluster
Next
From: Thomas Güttler
Date:
Subject: [GENERAL] Final pg_dumpall should happen in Single-User-Mode