From: Lazaro Garcia <lazaro3487@gmail.com>
To: pgpool-general@pgpool.net
To: pgsql-admin@postgresql.org
Subject: Why pgpool TPS is lowest versus postgresql direct connections?
Date: Wed, 8 Feb 2017 17:27:42 +0100
Message-ID: <002501d28228$46ff87e0$d4fe97a0$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
After installed Pgpool with 2 postgresql nodes with streaming replication, I
have noticed that access directly to postgresql is more efficient than
through pgpool.
I supposed that load balance could increase the transactions per second
executed because each node could receive more load, but the results shown
below are not expected.
This is the setup:
Pgpool 3.6.1 whit connection pooling, streaming replication mode and load
balancing mode.
2 PostgreSQL server 9.6.1 whit streaming replication.
For the tests I used sysbench and pgbench.
The results of sysbench:
Concurrent Users
1
20
50
100
PostgreSQL (TPS) Direct
1166
20936
25743
27344
Pgpool (TPS)
2240
7628
7013
6135
The results of pgbench
1
20
50
100
PostgreSQL (TPS) Direct
1403
6805
6194
5726
Pgpool (TPS)
511
5430
5528
4705
As you can see in both cases even with load balance, the total transactions
per second are lower.
Is this the expected behavior. Is there any way to allow more TPS when
pgpool is used?
There are other publications with similar results:
https://www.os3.nl/_media/2011-2012/courses/lia/rory_breuk_gerrie_veerman_-_
report.pdf (page 28)
http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg03326.html
Regards
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lazaro3487@gmail.com, pgpool-general@pgpool.net
Subject: Re: Why pgpool TPS is lowest versus postgresql direct connections?
In-Reply-To: <002501d28228$46ff87e0$d4fe97a0$@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox