Re: [Postgres-xc-general] What is the minimum server requirement for pgxc

[Michael P. <mic...@gm...>]

On Fri, Mar 21, 2014 at 10:13 PM, Juned Khan <jkh...@gm...> wrote:
> Hi Michael,
>
>
> 2) pgxc will be able to handle 500 concurrent calls on server ?
> Well yes, but a single Postgres server is able to handle that nicely
> as well if coupled with a connection pooler. I don't see much why
> multi-master is a requirement for such a low-number though as you seem
> to mean in your question.
>
>> I want to use multi-master because, I have my server in different states
>> as of now i have two servers but in future it will increase to four. And
>> one of
>> my table will have records more than one Billion, so i will make that
>> table
>> distributed so local query can executed on local servers.
>> I have attached the diagram of my requirement.
>
>
> Please suggest.
Don't do that.

Postgres-XC is designed to work with nodes located close to each
other, and OLTP applications. With a cluster having nodes distributed
geographically, your application performance would sink down because
of GTM (XID/snapshot obtention, sequence value obtention) and network
latency. This is the price to manage concurrency accurately.
-- 
Michael