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: (view raw, whole thread or download thread mbox)
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


> 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 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-2017 The PostgreSQL Global Development Group