Skip site navigation (1) Skip section navigation (2)

Re: Plannner favoring nested loop

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Abu Mushayeed <abumushayeed(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Plannner favoring nested loop
Date: 2007-05-07 21:37:33
Message-ID: 19019.1178573853@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Abu Mushayeed <abumushayeed(at)yahoo(dot)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 an plan 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

In response to

Responses

pgsql-admin by date

Next:From: Abu MushayeedDate: 2007-05-07 22:30:01
Subject: Re: Plannner favoring nested loop
Previous:From: Abu MushayeedDate: 2007-05-07 20:33:59
Subject: Plannner favoring nested loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group