Joe Van Dyk <joe@xxxxxxxxx> writes: > Hm, setting set join_collapse_limit = 9 seemed to fix the problem. Is that > my best/only option? Yup, that's what I was just about to suggest. You might want to use 10 or 12 in case some of your queries are a bit more complex than this one --- but don't go overboard, or you may find yourself with unreasonable planning time. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
