| From: | newtglobal postgresql_contributors <postgresql_contributors(at)newtglobalcorp(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | Yuya Watari <watari(dot)yuya(at)gmail(dot)com> |
| Subject: | Re: [PoC] Reducing planning time when tables have many partitions |
| Date: | 2025-03-12 07:23:32 |
| Message-ID: | 174176421219.294105.3395783202038263246.pgcf@coridan.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The following review has been posted through the commitfest application:
make installcheck-world: tested, failed
Implements feature: tested, failed
Spec compliant: tested, failed
Documentation: tested, failed
Hi Yuya,
Tested this patch and noted that this patch significantly improves query planning time, especially as the number of partitions increases. While the impact is minimal for small partition counts (2–8), the improvement becomes substantial from 16 partitions onward, reaching up to ~86.6% reduction at 768 partitions. Larger partitions (512–1024) see a dramatic speedup, cutting planning time by over 2.7 seconds. The results confirm that the patch optimizes partitioned query execution efficiently. This enhancement is crucial for databases handling large partitioned tables, leading to better performance and scalability.
Regards,
NewtGlobal PostgreSQL contributors
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-03-12 07:24:27 | Re: Non-text mode for pg_dumpall |
| Previous Message | newtglobal postgresql_contributors | 2025-03-12 07:21:47 | Re: [PoC] Add CANONICAL option to xmlserialize |