[pgpool-committers: 5498] pgpool: Add new 'enable_shared_relcache' parameter.

Takuma Hoshiai hoshiai at sraoss.co.jp
Mon Feb 25 16:37:35 JST 2019


Add new 'enable_shared_relcache' parameter.

The relation cache were stored in local cache of child processes, so all child processes executed same query to get relation cache.
If enable_shared_relcache is on, the relation cache is stored in memory cache and all child process share it.
It will expect to reduce the load that same query is executed.

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/misc-config.sgml                   |  48 ++++++
doc/src/sgml/misc-config.sgml                      |  29 ++++
src/config/pool_config_variables.c                 |  10 ++
src/include/pool_config.h                          |   3 +-
src/include/query_cache/pool_memqcache.h           |   7 +-
src/main/pgpool_main.c                             |   4 +-
src/protocol/child.c                               |   5 +-
src/protocol/pool_process_query.c                  |   3 +-
src/query_cache/pool_memqcache.c                   | 151 +++++++++++++++--
src/sample/pgpool.conf.sample                      |   5 +
src/sample/pgpool.conf.sample-logical              |   5 +
src/sample/pgpool.conf.sample-master-slave         |   5 +
src/sample/pgpool.conf.sample-replication          |   5 +
src/sample/pgpool.conf.sample-stream               |   5 +
.../tests/025.enable_shared_relcache/test.sh       |  69 ++++++++
src/utils/pool_process_reporting.c                 |   7 +-
src/utils/pool_relcache.c                          | 186 ++++++++++++++++++++-
17 files changed, 516 insertions(+), 31 deletions(-)



More information about the pgpool-committers mailing list