[pgpool-general: 4421] pgpool increase performance

[Alessandro - Infopix]

Hi to All!

 

Can you help me to increase performance of my pgpool installation?

I've installed pgpool with postgres streaming replication hot_standby on but
now I've poor performance.

If I test with pgbench postgres directly with his command

 

/usr/pgsql-9.4/bin/pgbench -h myhost -U postgres -c 4 -j 2 -T 60 -S prova

 

Received output

 

starting vacuum...end.

transaction type: SELECT only

scaling factor: 100

query mode: simple

number of clients: 4

number of threads: 2

duration: 60 s

number of transactions actually processed: 893740

latency average: 0.269 ms

tps = 14895.495617 (including connections establishing)

tps = 14897.984048 (excluding connections establishing)

 

 

if I connect to postgresql trought pgpool 

 

/usr/pgsql-9.4/bin/pgbench -h myhost -p 9999 -U postgres -c 4 -j 2 -T 60 -S
prova 

Received output

 

starting vacuum...end.

transaction type: SELECT only

scaling factor: 100

query mode: simple

number of clients: 4

number of threads: 2

duration: 60 s

number of transactions actually processed: 767111

latency average: 0.313 ms

tps = 12785.033109 (including connections establishing)

tps = 12787.297287 (excluding connections establishing)

 

with hot_standby on of postgresql and load balancing on of pgpool read only
query become faster..it's right?

 

I tried to exclude standby server from pgpool pool and I've retried test but
I've the same latency

 

Can you help me to increase performance please?

There is parameter to set on postgresql.conf or in pgpool.conf? 

 

Thanksss

 

 

A.Baccanelli

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160209/d71eb7f7/attachment.html>