Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
Thanks you very much Craig for clearing these facts and sorry for mail sent only to you by mistake. -- Thanks & Regards, Amit Bondwal On Fri, Jul 17, 2015 at 6:19 PM, Craig Ringer wrote: > On 17 July 2015 at 19:37, Amit Bondwal wrote: > > Thank you very much all of you for quick response an

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 19:37, Amit Bondwal wrote: > Thank you very much all of you for quick response and clearing my mind. Please reply to the mailing list, not just to me directly. > One more question, can I run a databse of postgres 9.4 on postgres-XL > cluster? postgres-XL is based on PostgreSQ

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 15:02, Amit Bondwal wrote: > I looked at pg_shard, as per my understanding it is for nosql data, in our > case we are going to use postgresql RDBMS features without nosql, pg_shard > have lot on limitation as per our case. You'll find that _most_ products have a lot of limitat

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 17:33, Dorian Hoxha 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

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Dorian Hoxha
1,2,3: You can't shard with BDR. It's only for multimaster (at least for now). Please read the docs. On Fri, Jul 17, 2015 at 9:02 AM, Amit Bondwal wrote: > Hello everyone, > > We ae working on a application in which we are using posgresql as a > database. We are sure that in future it will exten

[GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
Hello everyone, We ae working on a application in which we are using posgresql as a database. We are sure that in future it will extend to level that we have to scale it horizontally. We have some tables which are going to be more than 90% of database size. I looked at pg_shard, as per my underst