Re: [Postgres-xc-general] High performance

[Tim K. <tk...@ut...>]

On Thu, Sep 12, 2013 at 6:49 AM, Bartłomiej Wójcik <
bar...@tu...> wrote:

> Hello,
>
> When I add every new node to my cluster the performance of the entire
> cluster decreases by 20 percent.
>
> Cluster scheme:
>
> Host1(vm1, IP1, 2core 4GB ram): gtm
> Host2(vm2, IP2, 2core 4GB ram): 1 gtm_proxy + 1 coordinator + 1 datanode
> Host3(vm3, IP3, 2core 4GB ram): 1 gtm_proxy + 1 coordinator + 1 datanode
> Host4(vm4, IP4, 2core 4GB ram): 1 gtm_proxy + 1 coordinator + 1 datanode
>
> I run pgbench (-S) and getting:    ~1200 tps (on each)
>
> when I use (host1 and host2 and host3) the result is: ~1500 tps (on each)
>
> when I use (host 1 and host 2) the result is: ~1800 tps
>
>
> Is this normal behavior ?
>
> All hosts  use the same  disk storage(very large  throughput  ~Gbit/s),
> cores  are not common, ramare not common
>
>
> Regards!
>
>
>
I'm a lurker on the list, but I thought pg-xc was not designed to maximize
transaction rate. Rather its designed for quickly completing a few very
large transactions.

THK


>
> ------------------------------------------------------------------------------
> How ServiceNow helps IT people transform IT departments:
> 1. Consolidate legacy IT systems to a single system of record for IT
> 2. Standardize and globalize service processes across IT
> 3. Implement zero-touch automation to replace manual, redundant tasks
> http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
http://www.keittlab.org/