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 667903B68B0 for ; Sat, 18 Dec 2004 04:26:34 +0000 (GMT) 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 07083-01 for ; Sat, 18 Dec 2004 04:26:31 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 2C2893A8A6E for ; Sat, 18 Dec 2004 04:26:28 +0000 (GMT) Received: (qmail 21042 invoked by uid 500); 18 Dec 2004 04:39:18 -0000 Date: Fri, 17 Dec 2004 22:39:18 -0600 From: Bruno Wolff III To: pgsql-performance@postgresql.org Subject: Re: Seqscan rather than Index Message-ID: <20041218043918.GA20619@wolff.to> Mail-Followup-To: pgsql-performance@postgresql.org References: <20041217011853.9E8FF3CADB0@svr1.postgresql.org> <41C2D936.3060901@archonet.com> <87acsdkjte.fsf@stark.xeocode.com> <20041217215627.GC8281@uio.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041217215627.GC8281@uio.no> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/236 X-Sequence-Number: 9611 On Fri, Dec 17, 2004 at 22:56:27 +0100, "Steinar H. Gunderson" wrote: > > I'm a bit unsure -- should counting ~3 million rows (no OIDs, PG 7.4, > everything in cache, 32-byte rows) take ~3500ms on an Athlon 64 2800+? It doesn't seem totally out of wack. You will be limited by the memory bandwidth and it looks like you get something on the order of a few hundred references to memory per row. That may be a little high, but it doesn't seem ridiculously high.