Hi Alvaro ,
looks like Xact slru buffer use a different way to control size, do we
need to increase Xact and how to increase that ? we plan to increase to
20 times size of existing buffers, any side impact to 20 times increase
these subtrans ?
+-+-+-
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
> Possible to increase Subtrans SLRU buffer size ?
Not at present -- you need to recompile after changing NUM_SUBTRANS_BUFFERS
in src/include/access/subtrans.h, NUM_MULTIXACTOFFSET_BUFFERS and
NUM_MULTIXACTMEMBER_BUFFERS in src/include/access/multixact.h.
one question:
we need to increase
>
>
> From this link, looks like "onfigurable buffer pool and partitioning the
> SLRU lock" is one the plan, maybe from v18,19 version,
> https://www.postgresql.org/message-id/202402221843.ibzvpndbacbi@alvherre.pgsql
>
James
> *From:* James Pang (chaolpan)
> *Sent:* Tuesday, February 6, 202
