[pgpool-general: 4908] Performance with pgpool is lower than without pgpool

[JotaComm]

​Hello,

I was analyzing my environment with pgpool and postgres. For example: My
select queries are taking about 2 times more that direct connections with
the postgres.

The pgpool replication sends all write requests to all servers in the
cluster. For this reason the performance decreases?

The parametes are:

num_init_children = 200

max_pool = 2

child_life_time = 300

connection_life_time = 300

client_idle_limit = 300

load_balance_mode = on

master_slave_mode = on

master_slave_sub_mode = 'stream'

My pgpool version is pgpool-II version 3.5.3 (ekieboshi)

My postgresql version is 9.4.4

My SO is CentOS release 6.7 (Final)

Thank you

Best regards​


-- 
JotaComm
http://jotacomm.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160812/ac95f46d/attachment.html>