Re: Speedup of relation deletes during recovery

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Speedup of relation deletes during recovery
Дата
Msg-id CAHGQGwHTvE_uBeYisE+Gd_dUx5RZpOPk=9_v-VQPvA4azY59dg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Speedup of relation deletes during recovery  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: Speedup of relation deletes during recovery  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
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.

Regards,

-- 
Fujii Masao


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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Speedup of relation deletes during recovery
Следующее
От: Dent John
Дата:
Сообщение: Re: Query Rewrite for Materialized Views (Postgres Extension)