Skip site navigation (1) Skip section navigation (2)

Re: strange query behavior

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tim Jones" <TJones(at)optio(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange query behavior
Date: 2006-12-13 22:36:49
Message-ID: 12548.1166049409@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"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

In response to

Responses

pgsql-performance by date

Next:From: Tim JonesDate: 2006-12-13 22:44:36
Subject: Re: strange query behavior
Previous:From: James CloosDate: 2006-12-13 22:35:26
Subject: Re: Optimizing a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group