[pgpool-hackers: 1593] Re: Load balancing with synchronous replication

Tatsuo Ishii ishii at postgresql.org
Thu May 26 18:42:52 JST 2016


>> I think problem with your idea is the overhead for pgpool-II to ask
>> status to PostgreSQL. This inquery will happen with every single query
>> sent from clients to pgpool-II, and that could cause visible performance
>> degration. What do you think?
> 
> Yeah, I didn't mean for every query.  I suppose something periodic
> like sr_check_period.

That's and idea. I think the patch you plan to propose for 10.0 will
greatly help this functionality.

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-hackers mailing list