public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: Mauro Gatti <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included)
Date: Fri, 6 Mar 2026 10:05:55 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGWVher6_MmYHUWYZ+=Yu_-4udnw+Jwif_uxQ8NpPXMjhgpy4g@mail.gmail.com>
References: <CAGWVhepg33bkfuDcPMy7GU5RQJss7GUd4jTNoB25wNT4X86zeA@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAGWVher6_MmYHUWYZ+=Yu_-4udnw+Jwif_uxQ8NpPXMjhgpy4g@mail.gmail.com>
On 6/3/26 09:24, Mauro Gatti wrote:
> In any case, I don’t think there are other workable solutions without
> changing the code.
The gist of the issue is hidden [anti]correlations between columns.
I like the idea of grouping columns into a custom type when an object in
the data model is defined by several properties. This approach could
help reduce the number of clauses, hide correlations within an object,
and enable the use of histogram statistics.
I'm not sure if this idea is ready to use yet, or if Postgres has
everything needed to make it work well - just note.
--
regards, Andrei Lepikhov,
pgEdge
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox