[Pgpool-hackers] About query cache of pgpool-II

[Tatsuo Ishii]

> I understand what you mean. But I think,although the hash value of
> both " SELECT 'ABC' " and "select 'ABC" must be diffirent but they
> could point to the same result. And for example if you have executed "
> SELECT 'ABC' " first and cached the result. Then you execute " sElEcT
> 'ABC' " for the first time, we can't find a hash value for it , so we
> need to parse it, and then found it is the same as " SELECT 'ABC' ",
> so there are two hash item pointed to the same chached item. If we
> execute " sElEcT 'ABC' " again, we can find it is executed before and
> can get data directelly from the cache.
> 
> For the
>> SELECT 'ABC'
>> and
>> select 'abc'
> situation,  they are diffirent SQL.

Sharing cache data but different hash index entries would be an
interesting idea. However, I have lots of things todo (for example, I
need to deal with extended protocol). So I'm not sure we could include
the ide for 3.2 unless someone comes up with patches.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp