On Tue, Jan 28, 2025 at 5:30 PM Felipe López Montes <xocas89@gmail.com> 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';