Re: strange query behavior

Looks like 8.1.2

Tim Jones
Healthcare Project Manager
Optio Software, Inc.
(770) 576-3555

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, December 13, 2006 5:37 PM
To: Tim Jones
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] strange query behavior

"Tim Jones" <TJones(at)optio(dot)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