Postgres Pro
Downloads
Home   >   mailing lists

Re: Is BDR support distributed table on slave nodes with ACID and join support. - Mailing list pgsql-general

From Craig Ringer
Subject Re: Is BDR support distributed table on slave nodes with ACID and join support.
Date
Msg-id CAMsr+YFQmRDxNjztMrtcvMdrTy2UOfO1dkEQLYhjJsT1HgeCVg@mail.gmail.com
Whole thread Raw
In response to Re: Is BDR support distributed table on slave nodes with ACID and join support.  (Dorian Hoxha <dorian.hoxha@gmail.com>)
List pgsql-general
Tree view 
On 17 July 2015 at 17:33, Dorian Hoxha <dorian.hoxha@gmail.com> wrote:
> 1,2,3: You can't shard with BDR. It's only for multimaster (at least for
> now). Please read the docs.

You can kind-of shard using table partitioning, but the application
has to deal with shard integration because there's no cross-node
querying. So in practice it's no benefit over a bunch of standalone
databases.

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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Is BDR support distributed table on slave nodes with ACID and join support.
Next
From: Sachin Srivastava
Date:
Subject: Getting error "IST FATAL: the database system is in recovery mode"