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

From Aleksander Alekseev
Subject Re: [COMMITTERS] pgsql: Improve performance offind_all_inheritors()
Date
Msg-id 20170328195914.GA2265@e733.localdomain
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: Improve performance of find_all_inheritors()  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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.

[1] https://postgr.es/m/20170324132258.GB16830%40e733.localdomain

--
Best regards,
Aleksander Alekseev

pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Monitoring roles patch
Next
From: Tom Lane
Date:
Subject: Re: Monitoring roles patch