On Tue, Jul 30, 2024 at 11:34 AM Andrei Lepikhov wrote:
>
> Thanks for report. I see such cases frequently enough and the key
> problem here is data skew, as you already mentioned. Extended statistics
> doesn't help here. Also, because we can't estimate specific values
> coming from the outer Nest
On 29/7/2024 22:51, Jon Zeppieri wrote:
Of course, I'd prefer not to have to materialize this relation
explicitly. This particular query, for this particular user, benefits
from it, but similar queries or queries for different users may not.
I think the root of the problem is that population siz
Hi all,
I'm trying to come up with an efficient query, ideally without having
to coerce the planner into doing what I want, but I'm running up
against a problem with row estimates, and I'm curious if there's a
better way to address the problem than what I've come up with.
Here's a straightforward
