Postgres Pro
Downloads
Home   >   mailing lists

Plannner favoring nested loop - Mailing list pgsql-admin

From Abu Mushayeed
Subject Plannner favoring nested loop
Date
Msg-id 888904.7334.qm@web57103.mail.re3.yahoo.com
Whole thread Raw
Responses Re: Plannner favoring nested loop  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
Hello,
 
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.
 
Is there a way to this in postgres? I know about the "set enable..." commands. I was wondering if I can do it without the hints.
 
Thanks
Abu

Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.

pgsql-admin by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: FTS
Next
From: Tom Lane
Date:
Subject: Re: Plannner favoring nested loop