"Carlos H. Reimer" <carlos.reimer@xxxxxxxxxxxxx> writes: > In this case, I believe the best choice to improve the performance of this > particular SQL statement is adding the 'set join_collapse_limit = 1;' just > before the join statement, correct? That's a mighty blunt instrument. The real problem with your query is the misestimation of the join sizes --- are you sure the table statistics are up to date? Maybe you'd get better estimates with more statistics (ie, increase the stats target for these tables). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
