Re: Plannner favoring nested loop - Mailing list pgsql-admin

From Tom Lane
Subject Re: Plannner favoring nested loop
Date
Msg-id 19019.1178573853@sss.pgh.pa.us
Whole thread Raw
In response to Plannner favoring nested loop  (Abu Mushayeed <abumushayeed@yahoo.com>)
Responses Re: Plannner favoring nested loop  (Abu Mushayeed <abumushayeed@yahoo.com>)
List pgsql-admin
Abu Mushayeed <abumushayeed@yahoo.com> writes:
>   I am trying to determine if I can make the planner see that nested loop is very expensive while it is trying to do
anplan for a query and not pick that route.  

If it's doing that when it shouldn't, it's probably because it's
underestimated the number of rows in the outer relation.  Look to your
stats settings.

            regards, tom lane

pgsql-admin by date:

Previous
From: Abu Mushayeed
Date:
Subject: Plannner favoring nested loop
Next
From: Abu Mushayeed
Date:
Subject: Re: Plannner favoring nested loop