Re: MultiXact\SLRU buffers configuration

x4mmm@yandex-team.ru

View thread View on postgr.es

From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2020-07-08T07:03:54Z

Lists: pgsql-hackers

Attachments

v2-0001-Use-shared-lock-in-GetMultiXactIdMembers-for-offs.patch (application/octet-stream) patch v2-0001
v2-0002-Make-MultiXact-local-cache-size-configurable.patch (application/octet-stream) patch v2-0002
v2-0003-Add-conditional-variable-to-wait-for-next-MultXac.patch (application/octet-stream) patch v2-0003
(unnamed) (text/plain)


> 2 июля 2020 г., в 17:02, Daniel Gustafsson <daniel@yesql.se> написал(а):
> 
>> On 15 May 2020, at 02:03, Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote:
> 
>> Generally in such cases, condition variables would work.  In the
>> attached PoC, the reader side gets no penalty in the "likely" code
>> path.  The writer side always calls ConditionVariableBroadcast but the
>> waiter list is empty in almost all cases.  But I couldn't cause the
>> situation where the sleep 1000u is reached.
> 
> The submitted patch no longer applies, can you please submit an updated
> version?  I'm marking the patch Waiting on Author in the meantime.
Thanks, Daniel! PFA V2

Best regards, Andrey Borodin.

Commits

Rework new SLRU test with injection points
- 94a3373ac5c3 18.0 landed
injection_point: Add injection_points.stats
- 2e35c67f9568 18.0 landed
injection_points: Add initialization of shmem state when loading module
- b2b023aa3706 18.0 landed
Add injection-point test for new multixact CV usage
- 768a9fd5535f 18.0 landed
Use conditional variable to wait for next MultiXact offset
- a0e0fb1ba56f 17.0 landed
Improve performance of subsystems on top of SLRU
- 53c2a97a9266 17.0 landed
Adjust VACUUM hastup LP_REDIRECT comments.
- 325bc54eed4e 16.0 cited
Test replay of regression tests, attempt II.
- f47ed79cc8a0 15.0 cited