Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 174259FA28E for ; Wed, 13 Dec 2006 18:44:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 51289-06 for ; Wed, 13 Dec 2006 18:44:47 -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 4E0319FA162 for ; Wed, 13 Dec 2006 18:44:51 -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:44:36 -0500 Message-ID: <47668A1334CDBF46927C1A0DFEB223D39F7AAC@mail.optiosoftware.com> In-Reply-To: <12548.1166049409@sss.pgh.pa.us> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] strange query behavior Thread-Index: AccfBy49dN9YiiMaQU6biz0oYuqrOAAAQb2Q 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> From: "Tim Jones" To: "Tom Lane" Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/346 X-Sequence-Number: 22402 Looks like 8.1.2 Tim Jones Healthcare Project Manager Optio Software, Inc. (770) 576-3555 -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 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" writes: >> Which PG version is this exactly? Are you running with any=20 >> nondefault planner parameters? > Version 8.1 8.1.what? > Here are the planner constraints I believe we changed=20 > 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