[pgpool-committers: 10170] pgpool: Feature: new PGPOOL SET CACHE DELETE command.

Tatsuo Ishii ishii at postgresql.org
Mon Oct 21 19:29:08 JST 2024


Feature: new PGPOOL SET CACHE DELETE command.

The new PGPOOl SET command allows to delete query cache by specifying
the previous query used to create the query cache entry. example usage
is:

PGPOOL SET CACHE DELETE 'SELECT * FROM t1;'

This command is particularly useful for queries that are not
invalidated by the auto cache invalidation feature because the query
does not have any reference to tables.

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/ref/allfiles.sgml         |   1 +
doc.ja/src/sgml/ref/pgpool_set_cache.sgml | 131 ++++++++++++++++++++++++++++++
doc.ja/src/sgml/reference.sgml            |   1 +
doc/src/sgml/ref/allfiles.sgml            |   1 +
doc/src/sgml/ref/pgpool_set_cache.sgml    |  97 ++++++++++++++++++++++
doc/src/sgml/reference.sgml               |   1 +
src/include/parser/nodes.h                |   1 +
src/include/query_cache/pool_memqcache.h  |   2 +
src/parser/gram.y                         |  14 ++++
src/protocol/pool_proto_modules.c         |  13 +++
src/query_cache/pool_memqcache.c          |  53 ++++++++++++
11 files changed, 315 insertions(+)



More information about the pgpool-committers mailing list