[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:
https://pgpool.net/mediawiki/index.php/TODO#Add_PCP_command_to_invalidate_particular_query_cache

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


More information about the pgpool-general mailing list