| 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: | Whole Thread | Raw Message | 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.
| 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 |