Horton

Re: FW: huge SubtransSLRU and SubtransBuffer wait_event

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: James Pang <jamespang886@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-performance@lists.postgresql.org
Date: 2024-03-01T07:35:41Z
Lists: pgsql-performance 
On 2024-Mar-01, James Pang wrote:

> one question:
>      we need to increase all SLRU buffers together , MULTIXACT, XACT,
> Subtrans, COMMIT TS ,  for example, got all of them doubled based on
> existing size ?

No need.

> or only increase Subtrans , or Subtrans and multixact ?

Just increase the sizes for the ones that are causing you pain. You can
have a look at pg_stat_slru for some metrics that might be useful in
determining which are those.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/