logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

pcp_invalidate_query_cache - invalidate query cache contents

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.

Name

       pcp_invalidate_query_cache - invalidate query cache contents

Options

       See pcp_common_options(1).

pgpool-II 4.6.0                                       2023                         PCP_INVALIDATE_QUERY_CACHE(1)

Synopsis

pcp_invalidate_query_cache [options...]

See Also