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 B097C5281A for ; Sat, 11 Jun 2005 13:49:44 -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 11843-10 for ; Sat, 11 Jun 2005 16:49:35 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 888BD5281E for ; Sat, 11 Jun 2005 13:49:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5BGnWx0011820; Sat, 11 Jun 2005 12:49:32 -0400 (EDT) To: John A Meinel Cc: Clark Slater , pgsql-performance@postgresql.org Subject: Re: faster search In-reply-to: <42AA3598.4080001@arbash-meinel.com> References: <20050610132812.R94573@vbp2.vbp2.com> <42A9D556.7070108@arbash-meinel.com> <20050610200358.R40688@vbp2.vbp2.com> <42AA3598.4080001@arbash-meinel.com> Comments: In-reply-to John A Meinel message dated "Fri, 10 Jun 2005 19:51:36 -0500" Date: Sat, 11 Jun 2005 12:49:32 -0400 Message-ID: <11819.1118508572@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/259 X-Sequence-Number: 12896 John A Meinel writes: > I am a little surprised that it is taking 40s to scan only 400k rows, > though. Yeah, that seemed high to me too. Table bloat maybe? It would be interesting to look at the output of "vacuum verbose test" to see how much dead space there is. regards, tom lane