Re: increase size of pg_commit_ts buffers

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: increase size of pg_commit_ts buffers
Дата
Msg-id 39327D46-762C-472B-8264-307AA07A4EC4@yandex-team.ru
обсуждение исходный текст
Ответ на increase size of pg_commit_ts buffers  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: increase size of pg_commit_ts buffers  (Thomas Munro <thomas.munro@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: ERROR: invalid spinlock number: 0
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: 64-bit XIDs in deleted nbtree pages