>> Thanks for the advice. But I rather thought about bypassing the raw >> parser and the planner. i.e. use the query string (or its hash) as the >> index of the query cache. >> > > I think you need to know which tables are involved and if they were > modified.
Of course. While creating a cache entry for a SELECT, we need to analyze it and extract tables involved in the SELECT. The information should be stored along with the cache entry. 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) Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
