X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A26FA329E83 for ; Tue, 14 Sep 2004 18:29:11 +0100 (BST) 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 55234-10 for ; Tue, 14 Sep 2004 17:29:01 +0000 (GMT) Received: from lorax.kcilink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 909BD329E79 for ; Tue, 14 Sep 2004 18:29:01 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by lorax.kcilink.com (Postfix) with ESMTP id DF6D54018 for ; Tue, 14 Sep 2004 13:28:59 -0400 (EDT) Received: from lorax.kcilink.com ([127.0.0.1]) by localhost (lorax.kcilink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 41956-07 for ; Tue, 14 Sep 2004 13:28:59 -0400 (EDT) Received: by lorax.kcilink.com (Postfix, from userid 8) id 4856C3FEB; Tue, 14 Sep 2004 13:28:59 -0400 (EDT) To: pgsql-general@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.general Subject: Re: disk performance benchmarks Date: Tue, 14 Sep 2004 13:28:59 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 29 Message-ID: References: NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kcilink.com 1095182939 76361 65.205.34.180 (14 Sep 2004 17:28:59 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Tue, 14 Sep 2004 17:28:59 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Security Through Obscurity, berkeley-unix) Cancel-Lock: sha1:FCO1xVPZgX3MKdS0WdmeCZ8Up8U= X-Virus-Scanned: by amavisd-new at kcilink.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/639 X-Sequence-Number: 65845 >>>>> "SW" == Shane Wright writes: SW> But, we have now taken the plunge and I'm in a position to do some SW> benchmarking to actually get some data. Basically I was wondering if SW> anyone else had any particular recommendations (or requests) about the SW> most useful kinds of benchmarks to do. I did a bunch of benchmarking on a 14 disk SCSI RAID array comparing RAID 5, 10, and 50. My tests consisted of doing a full restore of a 30Gb database (including indexes) and comparing the times to do the restore, the time to make the indexes, and the time to vacuum. Then I ran a bunch of queries. It was damn near impossible to pick a 'better' RAID config, so I just went with RAID5. You can find many of my posts on this topic on the list archives from about august - october of last year. Basically, you have to approach it holistically to tune the system: Pg config parameters, memory, and disk speed are the major factors. That and your schema needs to be not idiotic. :-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/