Re: [Postgres-xc-general] pgbench suggestion

[Michael P. <mic...@gm...>]

On Tue, Nov 6, 2012 at 10:05 AM, Tatsuo Ishii <is...@po...> wrote:

> Hi,
>
> PostgreSQL Enterprise Consortium is planning to do a benchmark against
> Postges-XC. If we would use standard pgbench workload(pgbench default,
> -N, -S), what is a recommended portioning plan for pgbench_accounts?
>
If you want to show up the scalability, I recommend that you use pgbench
with option -k for initialization and launching, which is an option that
has been added in the pgbench version of XC available in its source code.
This allows to to a benchmark test by using bid as a distribution key so
this minimizes the amount of 2PC done when write operations involve several
nodes in a transaction.
$ pgbench --help
Initialization options:
  -k           distribute by primary key branch id - bid
Benchmarking options:
  -k           query with default key and additional key branch id (bid)

Depending on your cluster structure, I would also recommend you also to use
PREFERRED node with ALTER NODE (ALTER NODE nodename WITH (PREFERRED)) for
example with the Datanode that is on the same server as a Coordinator if
you use a structure of 1 Coordinator and 1 Datanode per server. This also
reduces the network load by having replicated table read being done on the
preferred node in priority. This is especially better if the node is local
of course.



>
> Any suggestions will be appreciated.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Michael Paquier
http://michael.otacoo.com