[pgpool-general: 8349] Jdbc driver harm cache hit ratio

Avi Raboah avi.raboah at gmail.com
Wed Aug 3 14:48:25 JST 2022


Hi,

I ran query load with two different drivers via pgpool with cache enabled.

1. With psychopg2 which generates simple query and I got 91% cache hit
ratio.
2. I ran the same load with jdbc which generates extended query and I got
0.03% cache hit ratio.

Any thoughts? Am I missing some configuration maybe?

Thanks,

Avi.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220803/440b8d79/attachment.htm>


More information about the pgpool-general mailing list