Re: increase size of pg_commit_ts buffers - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: increase size of pg_commit_ts buffers
Date
Msg-id 39327D46-762C-472B-8264-307AA07A4EC4@yandex-team.ru
Whole thread Raw
In response to increase size of pg_commit_ts buffers  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: increase size of pg_commit_ts buffers  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers

> 16 янв. 2021 г., в 03:07, Alvaro Herrera <alvherre@alvh.no-ip.org> написал(а):
>
> Andrey Borodin already has a patch to change the behavior for
> multixact, which is something we should perhaps also do.  I now notice
> that they're also reporting a bug in that thread ... sigh

I've tried in that thread [0] to do more intelligent optimisation than just increase number of buffers.
Though, in fact bigger memory had dramatically better effect that lock tricks.

Maybe let's make all SLRUs buffer sizes configurable?

Best regards, Andrey Borodin.

[0]
https://www.postgresql.org/message-id/flat/b4911e88-9969-aaba-f6be-ed57bd5fec36%40darold.net#ecfdfc8a40af563a0f8b1211266b6fcc


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: ERROR: invalid spinlock number: 0
Next
From: Masahiko Sawada
Date:
Subject: Re: 64-bit XIDs in deleted nbtree pages