X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5CEB528A9 for ; Mon, 27 Jun 2005 23:22:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76304-06 for ; Tue, 28 Jun 2005 02:22:16 +0000 (GMT) Received: from mail22.sea5.speakeasy.net (mail22.sea5.speakeasy.net [69.17.117.24]) by svr1.postgresql.org (Postfix) with ESMTP id D66EB52986 for ; Mon, 27 Jun 2005 23:22:15 -0300 (ADT) Received: (qmail 32521 invoked from network); 28 Jun 2005 02:22:20 -0000 Received: from dsl093-114-095.chi2.dsl.speakeasy.net (HELO mofo.meme.com) ([66.93.114.95]) (envelope-sender ) by mail22.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 28 Jun 2005 02:22:20 -0000 Received: from mofo (localhost.localdomain [127.0.0.1]) by mofo.meme.com (Postfix) with ESMTP id A9F616E421; Mon, 27 Jun 2005 22:11:25 -0500 (CDT) Date: Tue, 28 Jun 2005 03:11:25 +0000 From: "Karl O. Pinc" Subject: Re: Poor index choice -- multiple indexes of the same To: "Karl O. Pinc" Cc: josh@agliodbs.com, pgsql-performance@postgresql.org References: <1119913766l.4428l.2l@mofo> <200506271537.41797.josh@agliodbs.com> <1119926211l.11411l.2l@mofo> In-Reply-To: <1119926211l.11411l.2l@mofo> (from kop@meme.com on Mon Jun 27 21:36:51 2005) X-Mailer: Balsa 2.3.0 Message-Id: <1119928285l.11411l.4l@mofo> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/516 X-Sequence-Number: 13153 On 06/27/2005 09:36:51 PM, Karl O. Pinc wrote: > I'm doing this in a torture test script, loading data. > Every fibnocci number of rows * 100 I VACCUM ANALYZE. > So, 100, 200, 300, 500, 800, etc. (And of course disconnect my client and re-connect so as to use the new statistics. sure would be nice if I didn't have to do this.) Karl Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein