Horton

huge SubtransSLRU and SubtransBuffer wait_event

James Pang (chaolpan) <chaolpan@cisco.com>

View thread View on postgr.es
From: "James Pang (chaolpan)" <chaolpan@cisco.com>
To: "pgsql-performance@lists.postgresql.org" <pgsql-performance@lists.postgresql.org>
Date: 2024-02-01T11:50:57Z
Lists: pgsql-performance 
Hi,
   We have a Postgresqlv14.8 server, client use Postgresql JDBC connections, today, our server see a lot of  "SubtransBuffer" and "SubtransSLRU" wait_event. Could you help direct me what's the possible cause and how to resolve this waits ?

Thanks,

James