Man page - pgpool_set_cache(1)

Packages contains this manual

Package:  pgpool2
apt-get install pgpool2

Manuals in package:
• pcp_invalidate_query_cache(1)
• pgpool_adm_pcp_node_count(3)
• pcp_proc_info(1)
• pcp_recovery_node(1)
• pcp_common_options(1)
• pgpool_adm_pcp_pool_status(3)
• pcp_proc_count(1)
• pcp_log_rotate(1)
• pgpool_adm_pcp_node_info(3)
• pgpool_adm_pcp_attach_node(3)
• pcp_stop_pgpool(1)
• pcp_node_count(1)
• pgpool_setup(1)
• pcp_health_check_stats(1)
• pgpool_adm_pcp_detach_node(3)
• pgpool_adm_pcp_health_check_stats(3)
• pg_md5(1)
• pcp_promote_node(1)
• pcp_pool_status(1)
• pcp_detach_node(1)
• wd_cli(1)
• pg_enc(1)
• pcp_reload_config(1)
• pgpool_adm_pcp_proc_info(3)
• pcp_watchdog_info(1)
• pgproto(1)
• pgpool(8)
• watchdog_setup(1)
• pcp_node_info(1)
• pcp_attach_node(1)
Documentations in package:
• pgpool2

Manual

PGPOOL SET CACHE

NAME
SYNOPSIS
DESCRIPTION
EXAMPLES
SEE ALSO

---

NAME

PGPOOL_SET_CACHE - delete query cache

SYNOPSIS

PGPOOL SET CACHE DELETE 'query'

DESCRIPTION

The PGPOOL SET CACHE DELETE command deletes the query cache previously created by the query. The query string must be exactly identical to the previous query, including trailing ';'. Nevertheless if the query includes ' (single quore), it needs to be prefixed by ' like:

PGPOOL SET CACHE DELETE 'SELECT ''FOO'';';

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.

If you do not remember the previous query, you can use pcp_invalidate_query_cache (1) to delete all the query cache including the cache you want to delete. However it requires the Pgpool-II admin privilege.

Upon successful deletion of the query cache, this command emits a notice message:

NOTICE: query cache deleted. query: "query string"

If the cache does not exist or query cache is not enabled, it emits a notice message:

NOTICE: query cache does not exist for query: "query string"

EXAMPLES

Accidentally created an unwanted query cache. Delete it by using the command.

test=# /*FORCE QUERY CACHE*/SELECT current_timestamp;
current_timestamp
-------------------------------
2024-10-18 18:25:07.826423+09
(1 row)

test=# PGPOOL SET CACHE DELETE '/*FORCE QUERY CACHE*/SELECT current_timestamp;';
NOTICE: query cache deleted. query: "/*FORCE QUERY CACHE*/SELECT current_timestamp;"
SET

SEE ALSO

pcp_invalidate_query_cache (1)

---