| From: | Aleksander Alekseev <a(dot)alekseev(at)postgrespro(dot)ru> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Teodor Sigaev <teodor(at)sigaev(dot)ru>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [COMMITTERS] pgsql: Improve performance of find_all_inheritors() |
| Date: | 2017-03-28 19:59:15 |
| Message-ID: | 20170328195914.GA2265@e733.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-03-28 22:05:04 | pgsql: Remove direct uses of ItemPointer.{ip_blkid,ip_posid} |
| Previous Message | Simon Riggs | 2017-03-28 17:27:32 | pgsql: Correct grammar in error message |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-03-28 20:17:12 | Re: Monitoring roles patch |
| Previous Message | Dave Page | 2017-03-28 19:35:57 | Re: Monitoring roles patch |