[pgpool-general: 5804] Re: problem with processing time when using pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Fri Nov 10 08:56:43 JST 2017


> Not sure if anyone else has had this issue, we have an old version of pgpool (for postgres 9,1) and when we use this we have NO issues, even though we are using postgres 9.6 - we process some of our normal day to day processing and the speed is the same as if we go directly to postgres (port 5432).  However when we upgraded pgpool to the latest version our processing time takes 5 times as long.  This is horrible.  Has anyone else seen this??  Trying to see how we can resolve this.

To answer your question, we need:

- Exact Pgpool-II full version
- pgpool.conf
- The query string taking 5 times long, or self contained test case

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list