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