[PERFORM] Odd problem with planner choosing seq scan

refer this query run in < 1 second rather than > 45, but I'd really like to do that without having hacks like adding in pointless LIMIT clauses. Any help would be much appreciated. --Colin McGuigan ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Odd problem with planner choosing seq scan

ny performance costs. It doesn't seem to matter what the limit is -- LIMIT 9 also produces the desired plan, whereas no LIMIT produces the undesirable plan. --Colin McGuigan ---(end of broadcast)--- TIP 4: Have you search

[PERFORM] Odd problem with planner choosing seq scan

so there are no ongoing inserts/updates/deletes -- only selects. I'd really prefer this query run in < 1 second rather than > 45, but I'd really like to do that without having hacks like adding in pointless LIMIT clauses. Any help would be much appreciated. --Col