huge SubtransSLRU and SubtransBuffer wait_event

From: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: huge SubtransSLRU and SubtransBuffer wait_event
Date: 2024-02-01 11:50:57
Message-ID: PH0PR11MB51914D21F3FACE243EC5DD35D6432@PH0PR11MB5191.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2024-02-01 12:41:53 Re: huge SubtransSLRU and SubtransBuffer wait_event
Previous Message Laurenz Albe 2024-02-01 11:07:35 Re: Weird performance differences between cloud vendors