X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 756E49DC86D for ; Wed, 15 Mar 2006 14:49:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99022-02 for ; Wed, 15 Mar 2006 14:49:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 242819DC825 for ; Wed, 15 Mar 2006 14:49:05 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 15 Mar 2006 12:49:06 -0600 Message-Id: <44180D33.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0 Date: Wed, 15 Mar 2006 12:48:51 -0600 From: "Kevin Grittner" To: , "Andreas Kretschmer" Subject: Re: BETWEEN optimizer problems with single-value References: <44180105.EE98.0025.0@wicourts.gov> <20060315181735.GA22240@KanotixBox> In-Reply-To: <20060315181735.GA22240@KanotixBox> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.101 required=5 tests=[AWL=0.101] X-Spam-Score: 0.101 X-Spam-Level: X-Archive-Number: 200603/212 X-Sequence-Number: 17649 >>> On Wed, Mar 15, 2006 at 12:17 pm, in message <20060315181735.GA22240@KanotixBox>, Andreas Kretschmer wrote: > Kevin Grittner schrieb: > >> Attached is a simplified example of a performance problem we have seen, > > Odd. Can you tell us your PG- Version? I know we really should move to 8.1.3, but I haven't gotten to it yet. We're on a build from the 8.1 stable branch as of February 10th, with a patch to allow ANSI standard interpretation of string literals. (So this is 8.1.2 with some 8.1.3 changes plus the string literal patch.) If there are any changes in that time frame which might affect this issue, I could deploy a standard release and make sure that I see the same behavior. Let me know. -Kevin