Rich Doughty wrote:
can anyone explain the reason for the difference in the following 2 query plans, or offer any advice? the two queries are identical apart from the limit clause.
[snip] fwiw, join order makes no difference here either. i get a slightly different plan, but with LIMIT 1 postgres make a really strange planner choice. As before LIMIT > 1 the choice is logical and performance fine. - Rich Doughty
