Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2AEDD9FB539 for ; Tue, 8 May 2007 11:54:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 83015-09 for ; Tue, 8 May 2007 11:54:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31815.mail.mud.yahoo.com (web31815.mail.mud.yahoo.com [68.142.206.168]) by postgresql.org (Postfix) with SMTP id 9B1929FB4C7 for ; Tue, 8 May 2007 11:54:50 -0300 (ADT) Received: (qmail 88073 invoked by uid 60001); 8 May 2007 14:54:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Qo0wSYKucnAJLm7lkshonp3SJJtuNRDwS2q1IrxaFCnlX/2DguZMMuYw9dZk1iQ+V7WGvDI7PBRXBzUk8Ti3LYuN+nPlT/adr1NRUXRma6dogS9Q32iBmkKMmR81kduBFLyPlEvKUftB651caMlTmMINJJAl/BoeFB7AmKTole8=; X-YMail-OSG: wADtn8IVM1kZutmieCdqRpk8bi_2vmkoWSZFbIvj.ZLNIV5DtVoYqR94BgaaMaCa0DnwWZemaw-- Received: from [63.203.180.122] by web31815.mail.mud.yahoo.com via HTTP; Tue, 08 May 2007 07:54:48 PDT Date: Tue, 8 May 2007 07:54:48 -0700 (PDT) From: Richard Broersma Jr Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7 To: Susan Russo , pgsql-performance@postgresql.org Cc: harvsys@morgan.harvard.edu, russo@morgan.harvard.edu In-Reply-To: <200705081418.l48EIY8V026360@larrys.harvard.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <601821.86400.qm@web31815.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.863 tagged_above=0 required=5 tests=AWL=-1.307, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: * X-Archive-Number: 200705/120 X-Sequence-Number: 24510 --- Susan Russo wrote: > and accession like 'AY851043%' I don't know if you've tried refactoring your query, but you could try: AND accession BETWEEN 'AY8510430' AND 'AY8510439' -- where the last digit is ^ ^ -- lowest AND highest expected value Regards, Richard Broersma Jr.