[pgpool-general: 2603] Re: (no subject)

[Tatsuo Ishii]

> Dear PGPool Team
> 
> we have installed pgpool in our server because we need to use on memory query cache feature in pgpool, an then we try to compare which one the fastest beetwen with pgpool(on memory query cached) or not. that should be with on memory cache faster than whitout on memory cache like you said. but unfortunately after we try to compare we found that without on memory cache is faster than with memory cache.
> can you help us to find the root cause?
> 
> method testing
> get data from 100.000 until 1.000.000 from postgresql and counting time
> 
> try in different port 9999(pgpool) 54444(without pgpool)  
> 
> here i attached our pgpool configuration

I don't know how you exactly tested the query cache feature but I
suspect the cache hit rate is too low. You can check this by using
"show pool_cache" command.

If cache_hit_ratio is lower than 0.7, you are advised not to use the
query cache. See manual for more details.

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