[pgpool-general: 2601] (no subject)

masmu keren masmu_keren at yahoo.com
Fri Mar 7 16:56:58 JST 2014


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140306/e0278613/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 31378 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140306/e0278613/attachment-0001.obj>


More information about the pgpool-general mailing list