[pgpool-general: 8383] Query cache in shared memory bed performance

Avi Raboah avi.raboah at gmail.com
Tue Sep 13 00:57:54 JST 2022


Hi,

I ran 100 connections concurrently with pooling and query cache enabled,
and I saw a poor performance which indicting  on a very big query waits.

I found in code that there is a locking mechanism when fetching from shmem.

Could you please share why you make a critical section when pgpool trying
to read from cache?

Thanks,

Avi.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220912/4604d1fd/attachment.htm>


More information about the pgpool-general mailing list