Re: Speedup of relation deletes during recovery

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Speedup of relation deletes during recovery
Дата
Msg-id CAEepm=3c6oPJ-Lqi84r6Ob0GFFxCr+LWHbUDr-OnXx9UGo7vmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Speedup of relation deletes during recovery  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On Tue, Jun 19, 2018 at 6:13 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Sat, Jun 16, 2018 at 2:54 AM, Teodor Sigaev <teodor@sigaev.ru> wrote:
>>> We just had a customer hit this issue. I kind of wonder whether this
>>> shouldn't be backpatched: Currently the execution on the primary is
>>> O(NBuffers * log(ndrels)) whereas it's O(NBuffers * ndrels) on the
>>> standby - with a lot higher constants to boot.  That means it's very
>>> easy to get into situations where the standy starts to lag behind very
>>> significantly.
>>
>> +1, we faced with that too
>
> +1 to back-patch. As Horiguchi-san pointed out, this is basically
> the fix for oversight of commit 279628a0a7, not new feature.

+1

-- 
Thomas Munro
http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Keeping temporary tables in shared buffers
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: PATCH: backtraces for error messages