Re: strange query behavior

"Tim Jones" <TJones@optio.com> 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