Re: [Postgres-xc-general] Performance difference between postgress and postgres-XC

[Mason S. <ms...@tr...>]

On Mon, Feb 24, 2014 at 2:11 PM, Nirmal Sharma <sha...@gm...>wrote:

> Hi,
>
> I am using both postgress and postgress-XC and both are working fine but
> in terms of performance, they both are same(with same amount of data in
> both).
> I was hoping for better performance in pg-xc but it is just marginally
> better than PG and not much. So why then to use pg-xc?
>
> Can somebody tell me in what cases do we use pg-xc rather than PG?
>
>
It all depends on your workload and configuration. How many nodes and
physical servers are you using, and what is your workload and schema like?
Hopefully you are not replicating every table.

There are cases like TPC-C where you will experience a noticeable
improvement.  There are other cases like TPC-H where performance will be
worse than plain  PostgreSQL.


-- 
Mason Sharp

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions