public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Felipe López Montes <[email protected]>
Cc: [email protected]
Subject: Re: Simple query with Planner underestimating rows.
Date: Tue, 28 Jan 2025 21:12:03 -0500
Message-ID: <CAKAnmmKQcrF_psSgVy++hUfv02R0h8hgUo7fpnxmO6UFSvEYrQ@mail.gmail.com> (raw)
In-Reply-To: <CACJPJu-0u221Bker1yn=AJ3xJbW0j29mSM=EvkA_SXecv75hqw@mail.gmail.com>
References: <CACJPJu-0u221Bker1yn=AJ3xJbW0j29mSM=EvkA_SXecv75hqw@mail.gmail.com>
On Tue, Jan 28, 2025 at 5:30 PM Felipe López Montes <[email protected]>
wrote:
> For the sake of clarity and simplicity, I have disabled the nestloop join
> in the session because it involved a gather clause and parallel workers and
> was still underestimating rows, so the same problem happens with nestloop
> strategy too. Instead now the planner goes for a merge join ( if you still
> prefer me to send you the nestloop plan, I can do):
>
Yes, please, send the exact plan you are having problems with. Also, what
exactly is the performance issue? It seems your *second best plan* is
running in 36 milliseconds?
Cheers,
Greg
P.S. In the future, you can use this to quickly grab relevant settings:
select name, current_setting(name) from pg_settings where source <>
'default';
view thread (4+ messages) latest in thread
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]
Subject: Re: Simple query with Planner underestimating rows.
In-Reply-To: <CAKAnmmKQcrF_psSgVy++hUfv02R0h8hgUo7fpnxmO6UFSvEYrQ@mail.gmail.com>
* 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