[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