[pgpool-general: 7663] Re: How to cache a SQL that is using customized function?

Tatsuo Ishii ishii at sraoss.co.jp
Sun Aug 8 13:57:01 JST 2021

> In the SQL, I guess that's because the function `getEntityRelationshipChildren` make pgpool ignore the result of this SQL? This is a function I created by myself, it would select some other table and return the result, basically, I hope it get cached.
> According to the document, there is a setting called `cache_safe_memqcache_table_list.` but the document says it just support view and table, so, how could I make this SQL cached?

You need to register getEntityRelationshipChildren() as an "immutable"
function as documented in the doc.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list