Re: Speedup of relation deletes during recovery - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Speedup of relation deletes during recovery
Date
Msg-id CAHGQGwHTvE_uBeYisE+Gd_dUx5RZpOPk=9_v-VQPvA4azY59dg@mail.gmail.com
Whole thread Raw
In response to Re: Speedup of relation deletes during recovery  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Speedup of relation deletes during recovery
List 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 by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Speedup of relation deletes during recovery
Next
From: Dent John
Date:
Subject: Re: Query Rewrite for Materialized Views (Postgres Extension)