| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PG 18 release notes draft committed |
| Date: | 2025-05-07 01:17:15 |
| Message-ID: | aBq0myUhKHLNq2d9@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, May 7, 2025 at 09:27:14AM +1200, David Rowley wrote:
> On Wed, 7 May 2025 at 07:44, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > I think what you are saying is that this has to do with partition
> > processing of joins, but not the pruning process. I don't think a
> > non-partition joins are likely to hit 32 EquivalenceClasses.
>
> A query such as: SELECT * FROM table_with_lots_of_partitions ORDER BY
> col; will plan much faster now. No joins there.
Ah, interesting. I am guessing the ORDER BY requires the
EquivalenceClasses items. Applied patch attached. I don't think we can
make more precise wording for this item.
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| Attachment | Content-Type | Size |
|---|---|---|
| master.diff | text/x-diff | 600 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-05-07 01:18:11 | Re: disabled SSL log_like tests |
| Previous Message | Steve Chavez | 2025-05-07 00:34:04 | Re: Allow database owners to CREATE EVENT TRIGGER |