Re: Stop restarting of inner plan??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ramanujam H S Iyengar" <hals_ramu(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Stop restarting of inner plan??
Date: 2004-05-15 15:54:04
Message-ID: 7245.1084636444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Ramanujam H S Iyengar" <hals_ramu(at)hotmail(dot)com> writes:
> Can someone tell me how can i let the inner plan in a nestloop join NOT to
> restart for each tuple of the outer Plan ..

You can't. At least, not if you want the correct results from the join.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-05-15 16:16:47 Re: add server include files to default installation?
Previous Message Tom Lane 2004-05-15 15:36:11 Re: create type: recv and send function