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

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

Also, can you please explain what do you mean by TPC-C and TPC-H?
We are actually using PG for our reporting application that read the data
from database by running complex queries (query uses aggregate and wndows
functions) and we are using connection pools for users to connect and view
data from application. Also, users can changes the data ( update/insert)
from the application.
So do you think that our application is TPC-H?

Regards



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

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