[pgpool-general: 7111] Re: Query cache invalidation for functions?

Tatsuo Ishii ishii at sraoss.co.jp
Wed Jul 1 12:34:11 JST 2020

>> I think it is possible to do that if we implement the cache
>> invalidation feature in PCP command. Invoking PCP command is already
>> possible by using pgpool_adm extensions.
>> https://www.pgpool.net/docs/latest/en/html/pgpool-adm.html
>> pgpool_adm calls C function interface, which is similar to libpq, for
>> pcp commands.
>> So what we need are:
>> 1) implement new PCP command to invalidate query cache by specifying
>> table, something like:
>>    pcp_invalidate_query_cache [other standard options such as PCP port
>> number] table_name
>> 2) implement new pgpool_adm function something like:
>>    pgpool_adm_pcp_invalidate_query_cache([other pgpool_adm standard
>> parameters], 'table_name');
>> What do you think?
> This sounds great. I'll be glad to look into it.

Ok, I have added a TODO entry for this:

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list