Re: increase size of pg_commit_ts buffers

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: increase size of pg_commit_ts buffers
Date: 2021-02-15 10:55:49
Message-ID: 39327D46-762C-472B-8264-307AA07A4EC4@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 16 янв. 2021 г., в 03:07, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2021-02-15 11:14:48 Re: 64-bit XIDs in deleted nbtree pages
Previous Message Michael Paquier 2021-02-15 10:45:21 Re: ERROR: invalid spinlock number: 0