Re: [COMMITTERS] pgsql: Improve performance of find_all_inheritors() - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [COMMITTERS] pgsql: Improve performance of find_all_inheritors()
Date
Msg-id CA+TgmoZ6KbK3NuzHBkPWfDaN86us_tZQhgMG0nukaVoCBUngYQ@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Improve performance offind_all_inheritors()  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
List pgsql-hackers
On Tue, Mar 28, 2017 at 3:59 PM, Aleksander Alekseev
<a.alekseev@postgrespro.ru> wrote:
> Hi, Robert.
>
>> I'm a little worried that this will be noticeably slower when the
>> number of partitions is small, like 4 or 8 or 16.  In other places,
>> we've found it necessary to support both a list-based strategy and a
>> hash-based strategy to avoid regressing small cases (e.g.
>> join_rel_list + join_rel_hash in PlannerInfo, ResourceArray in
>> resowner.c, etc).
>
> I've checked it [1]. Apparently in this particular case patches make code
> faster on small amount of partitions as well.

Huh.  Well, in that case, cool.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Getting server crash after running sqlsmith
Next
From: Peter Eisentraut
Date:
Subject: Re: make check-world output