"Tim Jones" <TJones@xxxxxxxxx> writes: >> Which PG version is this exactly? Are you running with any nondefault >> planner parameters? > Version 8.1 8.1.what? > Here are the planner constraints I believe we changed > effective_cache_size and random_page_cost Those look reasonably harmless. My best bet at the moment is that you've got a pretty early 8.1.x release and are hitting one of the planner bugs that we fixed earlier this year. Not enough info to say for sure though. regards, tom lane
