Re: [Postgres-xc-general] pgbench suggestion

[Tatsuo I. <is...@po...>]

> (ccing XC general ML)
> 
> On Fri, Nov 16, 2012 at 12:40 PM, Tatsuo Ishii <is...@po...> wrote:
> 
>> We have up to 8 servers, where each server has data
>> node/coorrdinator/GTM proxy. We have GTM on a seprate server. Then we
>> execute multiple pgbench -k -S against the servers(each pgbench
>> connect to different server).
>>
> OK, this should not happen...
> How many max connections are you using per Coordinator

100.

> and how many
> Coordinators do you have?

Up to 4.
The number of coordinators are same as data nodes. So when we test 4
data nodes(suppose they are d1 to d4), we are doing something like
this:

on host c1: pgbench -c 100 -S -h d1
on host c2: pgbench -c 100 -S -h d2
on host c3: pgbench -c 100 -S -h d3
on host c4: pgbench -c 100 -S -h d4
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp