Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D8EA29FBB95 for ; Thu, 12 Apr 2007 20:37:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84519-04 for ; Thu, 12 Apr 2007 20:37:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from kittyhawk.tanabi.org (nc-67-76-229-82.sta.embarqhsd.net [67.76.229.82]) by postgresql.org (Postfix) with ESMTP id 01C3C9FBB94 for ; Thu, 12 Apr 2007 20:37:31 -0300 (ADT) Received: from kittyhawk.tanabi.org (localhost [127.0.0.1]) by kittyhawk.tanabi.org (8.13.8/8.13.8) with ESMTP id l3CNS2j9026563; Thu, 12 Apr 2007 19:28:02 -0400 (EDT) Received: from localhost (cheetah@localhost) by kittyhawk.tanabi.org (8.13.8/8.13.8/Submit) with ESMTP id l3CNS25Z026559; Thu, 12 Apr 2007 19:28:02 -0400 (EDT) X-Authentication-Warning: kittyhawk.tanabi.org: cheetah owned process doing -bs Date: Thu, 12 Apr 2007 19:28:02 -0400 (EDT) From: Steve To: Tom Lane cc: Scott Marlowe , PostgreSQL Performance Subject: Re: Strangely Variable Query Performance In-Reply-To: <10067.1176420549@sss.pgh.pa.us> Message-ID: References: <57271CC2-BCB1-4ACA-A177-4FF64F1BC33F@brandeis.edu> <16E9A17C-ADFA-43B2-B7EA-5C7A4D7E96D1@event-s.net> <0914C05F-BA1B-4A6C-A1B1-52256BC851A4@event-s.net> <1176396964.13754.16.camel@state.g2switchworks.com> <1176414724.13754.23.camel@state.g2switchworks.com> <1176416077.13754.26.camel@state.g2switchworks.com> <9833.1176418809@sss.pgh.pa.us> <10067.1176420549@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/278 X-Sequence-Number: 24155 It's a redhat enterprise machine running AMD x64 processors. Linux ers3.dddcorp.com 2.6.9-42.0.10.ELsmp #1 SMP Fri Feb 16 17:13:42 EST 2007 x86_64 x86_64 x86_64 GNU/Linux It was compiled by me, straight up, nothing weird at all, no odd compiler options or wahtever :) So yeah :/ I'm quite baffled as well, Talk to you later, Steve On Thu, 12 Apr 2007, Tom Lane wrote: > Steve writes: >> Here's my planner parameters: > > I copied all these, and my 8.2.x still likes the bitmap scan a lot > better than the seqscan. Furthermore, I double-checked the CVS history > and there definitely haven't been any changes in that area in REL8_2 > branch since 8.2.3. So I'm a bit baffled. Maybe the misbehavior is > platform-specific ... what are you on exactly? Is there anything > nonstandard about your Postgres installation? > > regards, tom lane >