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 A9FAF5388E for ; Sat, 23 Apr 2005 00:09:37 -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 70755-04 for ; Sat, 23 Apr 2005 03:09:26 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8B29653622 for ; Sat, 23 Apr 2005 00:09:22 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 8EE8215534; Fri, 22 Apr 2005 22:09:20 -0500 (CDT) Date: Fri, 22 Apr 2005 22:09:20 -0500 From: "Jim C. Nasby" To: pgsql-performance@postgresql.org Subject: Interesting numbers on a CREATE INDEX Message-ID: <20050423030920.GZ58835@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/633 X-Sequence-Number: 12030 Building a single-column index on a dual opteron with 4G of memory, data on a 4 SATA RAID10; OS, logs and tempsace on a SATA mirror, with sort_mem set to 2.5G, create index is actually CPU bound for large portions of time. The postgresql process and system time are accounting for an entire CPU, and systat (this is a FreeBSD5.2 box) is generally showing 80% utilization on the RAID10 and 40% on the mirror. Not a performance problem, but I thought some people might be interested. The RAID10 is doing about 28-32MB/s, I would think this wouldn't be enough to swamp the CPU but I guess I would be thinking wrong. BTW, the column I'm indexing is a bigint with a low correlation. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"