X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E7981D1C4EE for ; Tue, 29 Jul 2003 15:15:07 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 77814-01 for ; Tue, 29 Jul 2003 12:14:07 -0300 (ADT) Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 3E6B3D1C4CD for ; Tue, 29 Jul 2003 12:15:06 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 6B5CD3E86 for ; Tue, 29 Jul 2003 11:15:05 -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 SMTP id 37520-02 for ; Tue, 29 Jul 2003 11:14:55 -0400 (EDT) Received: by lorax.kciLink.com (Postfix, from userid 8) id 1AF6D3E23; Tue, 29 Jul 2003 11:14:55 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: Tuning PostgreSQL Date: Tue, 29 Jul 2003 11:14:54 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 25 Message-ID: References: <873cgvpylu.fsf@stark.dyndns.tv> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kciLink.com 1059491695 92135 216.194.193.105 (29 Jul 2003 15:14:55 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Tue, 29 Jul 2003 15:14:55 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code, berkeley-unix) Cancel-Lock: sha1:btXw58ZCAcntR4NMiOSnOO5FxBo= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/464 X-Sequence-Number: 2757 >>>>> "GS" == Greg Stark writes: GS> "scott.marlowe" writes: GS> But you have to actually test your setup in practice to see if it GS> hurts. A big data warehousing system will be faster under RAID5 GS> than under RAID1+0 because of the extra disks in the GS> stripeset. The more disks in the stripeset the more bandwidth you GS> get. Anyone have ideas on 14 spindles? I just ordered a disk subsystem with 14 high speed (U320 15kRPM) SCSI disks to hook up with a dell PERC3/DC controller (only 128MB cache, though). My plan was to do RAID10, but I think I'll play with RAID5 again and see which gives me the best performance. Unfortunatly, it is difficult to recreate the highly fragmented tables I have now (vacuum full takes over 14 hours on one of the tables) so I'm not sure how to best compare them. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/