>> If any of the tables were modified, cache entries using the table must be > removed. >> (these are already implemented in Pgpool-II's in memory query cache) > > How do you identify updates made from a pl/pgsql procedure?
Pgpool-II does not invalidate query cache in that case. I think in-core query cache could deal with the case (probably as Michael suggested). Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
