On Nov 16, 2007 3:36 PM, Josh Trutwin <josh@xxxxxxxxxxxxxxxxxxx> wrote: > > Agreed. IMHO, there's nothing wrong with nested-loop join as long > > as it's being used properly. > > Can you explain further please? (I'm not disagreeing with you, just > want to know when nested loops are not used properly - does the > planner make mistakes that you have to watch out for?) As long as statistics are updated properly, it's generally not an issue. You just don't want the system using a nested-loop join incorrectly (like when table sizes are equal, the outer table is larger than the inner table, or the inner table itself is overly large). -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@xxxxxxxxxxxxxxxx Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
