"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
> 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
In response to
pgsql-performance by date
|Next:||From: Tim Jones||Date: 2006-12-13 22:44:36|
|Subject: Re: strange query behavior |
|Previous:||From: James Cloos||Date: 2006-12-13 22:35:26|
|Subject: Re: Optimizing a query|