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/
