"Carlos H. Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> 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