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

[Ashutosh B. <ash...@en...>]

On Tue, Feb 25, 2014 at 4:47 AM, 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
>
>
For an apple to apple comparison, it's better to have Postgres and each of
the coordinator/datanode of XC deployed on same kind of configuration. From
the description, it looks like single Postgres is getting better hardware.
So, it's not surprising to see XC not getting at-par performance when
compared to PG.

>
>
>  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?
>
>
This distribution looks good. Make sure that you are using the right keys
for distributed tables. Please check my presentation at
http://www.youtube.com/watch?v=T1OPKvyj87Q. That might give some more hints
as to how to choose right distribution strategy.


> 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
>>
>>
>>
>
>
> ------------------------------------------------------------------------------
> Flow-based real-time traffic analytics software. Cisco certified tool.
> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
> Customize your own dashboards, set traffic alerts and generate reports.
> Network behavioral analysis & security monitoring. All-in-one tool.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company