Re: [HACKERS] Detrimental performance impact of ringbuffers on performance

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Detrimental performance impact of ringbuffers on performance
Date: 2019-05-08 16:35:06
Message-ID: 38585452-71BB-4B2E-BED9-3439D3956F83@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 8 мая 2019 г., в 1:16, Andres Freund <andres(at)anarazel(dot)de> написал(а):
>
> We probably can't remove the ringbuffer concept from these places, but I
> think we should allow users to disable them. Forcing bulk-loads, vacuum,
> analytics queries to go to the OS/disk, just because of a heuristic that
> can't be disabled, yielding massive slowdowns, really sucks.

If we will have scan-resistant shared buffers eviction strategy [0] - we will not need ring buffers unconditionally.
Are there any other reasons to have these rings?

Best regards, Andrey Borodin.

[0] https://www.postgresql.org/message-id/flat/89A121E3-B593-4D65-98D9-BBC210B87268%40yandex-team.ru

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2019-05-08 16:41:31 Re: Statistical aggregate functions are not working with PARTIAL aggregation
Previous Message Tomas Vondra 2019-05-08 15:30:37 Re: Statistical aggregate functions are not working with PARTIAL aggregation