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

Re: strange query behavior

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

In response to

Responses

pgsql-performance by date

Next:From: Tim JonesDate: 2006-12-13 22:54:06
Subject: Re: strange query behavior
Previous:From: Tom LaneDate: 2006-12-13 22:36:49
Subject: Re: strange query behavior

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