Man page - pcp_invalidate_query_cache(1)
Packages contas this manual
- pcp_stop_pgpool(1)
- pgpool_adm_pcp_attach_node(3)
- pcp_attach_node(1)
- pgpool_adm_pcp_node_count(3)
- pcp_recovery_node(1)
- pcp_log_rotate(1)
- pcp_detach_node(1)
- pcp_proc_info(1)
- pcp_node_info(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pg_enc(1)
- wd_cli(1)
- pgproto(1)
- pgpool_adm_pcp_health_check_stats(3)
- pcp_proc_count(1)
- pcp_watchdog_info(1)
- pcp_node_count(1)
- pcp_health_check_stats(1)
- pcp_reload_config(1)
- pcp_pool_status(1)
- pcp_invalidate_query_cache(1)
- pcp_promote_node(1)
- watchdog_setup(1)
- pgpool_setup(1)
- pgpool_adm_pcp_proc_info(3)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_detach_node(3)
- pg_md5(1)
- pgpool(8)
- pcp_stop_pgpool(1)
- pgpool_adm_pcp_attach_node(3)
- pcp_attach_node(1)
- pgpool_adm_pcp_node_count(3)
- pcp_recovery_node(1)
- pcp_log_rotate(1)
- pcp_detach_node(1)
- pcp_proc_info(1)
- pcp_node_info(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pg_enc(1)
- wd_cli(1)
- pgproto(1)
- pgpool_adm_pcp_health_check_stats(3)
- pcp_proc_count(1)
- pcp_watchdog_info(1)
- pcp_node_count(1)
- pcp_health_check_stats(1)
- pcp_reload_config(1)
- pcp_pool_status(1)
- pcp_invalidate_query_cache(1)
- pcp_promote_node(1)
- watchdog_setup(1)
- pgpool_setup(1)
- pgpool_adm_pcp_proc_info(3)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_detach_node(3)
- pg_md5(1)
- pgpool(8)
apt-get install pgpool2
apt-get install pgpool2
Manual
| PCP_INVALIDATE_QUERY_CACHE(1) | pgpool-II 4.7.1 Documentation | PCP_INVALIDATE_QUERY_CACHE(1) |
NAME
pcp_invalidate_query_cache - invalidate query cache contents
SYNOPSIS
pcp_invalidate_query_cache [options...]
DESCRIPTION
pcp_invalidate_query_cache places a query cache invalidation request on the shared memory area. The request is processed by one of Pgpool-II child process, which corresponds to each pgpool client session, when a message from the client is processed. This means that if there's no client connecting to Pgpool-II, or all clients are sitting idle, the request will not be processed until next message arrives.
Although this command does not modifies the statistics data shown by SHOW POOL_CACHE (SHOW_POOL_CACHE(1)), part of the statistics data is affected since this command invalidate the contents of query cache. num_cache_hits and num_selects continue to increase after the query cache invalidated. used_hash_entries, num_cache_entries and used_cache_entries_size starts off with 0. free_cache_entries_size will increase.
If memory_cache_enabled is false, this command emits an error and exits.
OPTIONS
See pcp_common_options(1).
| 2023 | pgpool-II 4.7.1 |