Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id BBFEA9FA28E
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 18:54:18 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 28495-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Dec 2006 18:54:09 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mail.optiosoftware.com (mail.optio.com [192.216.93.10])
	by postgresql.org (Postfix) with ESMTP id 714759FA162
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Dec 2006 18:54:09 -0400 (AST)
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: strange query behavior
Date: Wed, 13 Dec 2006 17:54:06 -0500
Message-ID: <47668A1334CDBF46927C1A0DFEB223D39F7AB0@mail.optiosoftware.com>
In-Reply-To: <458083E9.8000908@zeut.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [PERFORM] strange query behavior
Thread-Index: AccfCTYn1r5YlOqGTpC8gKJdUOL1vwAADbrQ
References: <47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com>
	<10648.1166037392@sss.pgh.pa.us>
	<47668A1334CDBF46927C1A0DFEB223D39F79FA@mail.optiosoftware.com>
	<12115.1166047135@sss.pgh.pa.us>
	<47668A1334CDBF46927C1A0DFEB223D39F7A98@mail.optiosoftware.com>
	<12548.1166049409@sss.pgh.pa.us>
	<47668A1334CDBF46927C1A0DFEB223D39F7AAC@mail.optiosoftware.com>
	<458083E9.8000908@zeut.net>
From: "Tim Jones" <TJones@optio.com>
To: "Matthew O'Connor" <matthew@zeut.net>
Cc: <pgsql-performance@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/347
X-Sequence-Number: 22403

That's what I did and got 8.1.2 ... do you want gcc version etc 3.3.2
powerpc aix5.2

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

-----Original Message-----
From: Matthew O'Connor [mailto:matthew@zeut.net]=20
Sent: Wednesday, December 13, 2006 5:51 PM
To: Tim Jones
Subject: Re: [PERFORM] strange query behavior

 From psql perform: select version();
and send us that output.

Tim Jones wrote:
> Looks like 8.1.2
>=20
> Tim Jones
> Healthcare Project Manager
> Optio Software, Inc.
> (770) 576-3555
>=20
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, December 13, 2006 5:37 PM
> To: Tim Jones
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] strange query behavior
>=20
> "Tim Jones" <TJones@optio.com> writes:
>>> Which PG version is this exactly?  Are you running with any=20
>>> nondefault planner parameters?
>=20
>> Version 8.1
>=20
> 8.1.what?
>=20
>> Here are the planner constraints I believe we changed=20
>> effective_cache_size and random_page_cost
>=20
> Those look reasonably harmless.
>=20
> My best bet at the moment is that you've got a pretty early 8.1.x=20
> release and are hitting one of the planner bugs that we fixed earlier=20
> this year.  Not enough info to say for sure though.
>=20
> 			regards, tom lane
>=20
> ---------------------------(end of=20
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>=20