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

[Nirmal S. <sha...@gm...>]

*This is my postgres box config:*
  Mem             : 32GB  Cores           : 16  model name      : Intel(R)
Xeon(R) CPU           E5630  @ 2.53GHz  stepping        : 2  cpu
MHz         : 2527.184  cache size      : 12288 KB
*This is my pg-xc (1 cordinator and 3 data node cluster) config:*

(All the 4 physical boxes are same with below mentioned config)
 Mem             : 24GB  Cores:            8  Model name:    stepping
: 5  cpu MHz         : 1994.961  cache size      : 4096 KB



 In Pg-xc, only my dimension tables are replicated and facts are hash key
distributed. Data and other things are same in pg and pg-xc.
My pg-xc is giving me only marginal better performance than pg and thats
the reason i am wondering whether to use pg-xc or not?

Regards
~Nirmal


On Mon, Feb 24, 2014 at 3:09 PM, Mason Sharp <ms...@tr...>wrote:

>
>
>
> 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
>
>
>