[pgpool-committers: 5383] pgpool: Implement new feature not to accept incoming connections.

Tatsuo Ishii ishii at sraoss.co.jp
Tue Dec 4 16:26:38 JST 2018


Implement new feature not to accept incoming connections.

Currently Pgpool-II accepts up to num_init_children frontends and
queues up more connection requests until one of child process becomes
free. This mostly works well, but if each session take long time, the
queue grows long and the whole system does not work smoothly.

To overcome the problem, I propose a new way to deal with many
connection requests from frontend: just complain and refuses to
connect to Pgpool-II if number of num_init_children is already filled
up. This is exactly the same behavior as PostgreSQL.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2018-November/003153.html

Patch by Tatsuo Ishii.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=693a6284cf2dfc2e60d5a2489c9ee5167defc3dc

Modified Files
--------------
doc.ja/src/sgml/connection-settings.sgml   | 59 ++++++++++++++++++++++++++++--
doc/src/sgml/connection-settings.sgml      | 38 ++++++++++++++++++-
src/config/pool_config_variables.c         | 11 ++++++
src/include/pool_config.h                  |  1 +
src/protocol/child.c                       | 40 +++++++++++++++++---
src/sample/pgpool.conf.sample              |  4 ++
src/sample/pgpool.conf.sample-logical      |  4 ++
src/sample/pgpool.conf.sample-master-slave |  4 ++
src/sample/pgpool.conf.sample-replication  |  4 ++
src/sample/pgpool.conf.sample-stream       |  4 ++
src/utils/pool_process_reporting.c         |  5 +++
11 files changed, 164 insertions(+), 10 deletions(-)



More information about the pgpool-committers mailing list