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 70C888B9E64 for ; Tue, 1 Feb 2005 13:58:47 +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 76591-04 for ; Tue, 1 Feb 2005 13:58:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by svr1.postgresql.org (Postfix) with ESMTP id 2D5548B9CF9 for ; Tue, 1 Feb 2005 13:58:39 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so1020613wra for ; Tue, 01 Feb 2005 05:58:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=ed6UQ91oOP0GD0oM8VQTcXFJ/Zkt0nPG1Vvs75kpaOoZw7rgBzcWESv0zRwnswY9bJyIy872Peaj1sn33S1ijb4FVEajDs8q5abyyI941YZ8+dKMCGrkltSVEFlMhEy2m+DLsy3r5JyeaMYP/1T8xyB0weTHT1OeeKJIppADCg4= Received: by 10.54.26.74 with SMTP id 74mr302341wrz; Tue, 01 Feb 2005 05:58:34 -0800 (PST) Received: by 10.54.18.59 with HTTP; Tue, 1 Feb 2005 05:58:34 -0800 (PST) Message-ID: <33c6269f05020105585b25794b@mail.gmail.com> Date: Tue, 1 Feb 2005 08:58:34 -0500 From: Alex Turner Reply-To: alex@neteconomist.com To: "Jim C. Nasby" Subject: Re: High end server and storage for a PostgreSQL OLTP system Cc: Cosimo Streppone , Postgresql Performance list In-Reply-To: <20050201112727.GF32356@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <41FE97FC.3060106@streppone.it> <20050201045645.GC32356@decibel.org> <41FF2337.7070809@streppone.it> <20050201112727.GF32356@decibel.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/18 X-Sequence-Number: 10347 To be honest I've used compaq, dell and LSI SCSI RAID controllers and got pretty pathetic benchmarks from all of them. The best system I have is the one I just built: 2xOpteron 242, Tyan S2885 MoBo, 4GB Ram, 14xSATA WD Raptor drives: 2xRaid 1, 1x4 disk Raid 10, 1x6 drive Raid 10. 2x3ware (now AMCC) Escalade 9500S-8MI. This system with fsync on has managed 2500 insert transactions/sec (granted they are simple transactions, but still). RAID 10 is a stripe of mirrors. RAID 10 give you the best read and write performance combined. RAID 5 gives very bad write perfomance, but good read performance. With RAID 5 you can only loose a single drive and rebuild times are slow. RAID 10 can loose up to have the array depending on which drives without loosing data. I would be interested in starting a site listing RAID benchmarks under linux. If anyone is interested let me know. I would be interested in at least some bonnie++ benchmarks, and perhaps other if people would like. Alex Turner NetEconomist On Tue, 1 Feb 2005 05:27:27 -0600, Jim C. Nasby wrote: > On Tue, Feb 01, 2005 at 07:35:35AM +0100, Cosimo Streppone wrote: > > >You might look at Opteron's, which theoretically have a higher data > > >bandwidth. If you're doing anything data intensive, like a sort in > > >memory, this could make a difference. > > > > Would Opteron systems need 64-bit postgresql (and os, gcc, ...) > > build to have that advantage? > > Well, that would give you the most benefit, but the memory bandwidth is > still greater than on a Xeon. There's really no issue with 64 bit if > you're using open source software; it all compiles for 64 bits and > you're good to go. http://stats.distributed.net runs on a dual opteron > box running FreeBSD and I've had no issues. > > > >RAID10 will be faster than RAID1. > > > > Sorry Jim, by RAID10 you mean several raid1 arrays mounted on > > different linux partitions? Or several raid1 arrays that > > build up a raid0 array? In the latter case, who decides which > > data goes in which raid1 array? Raid Adapter? > > You should take a look around online for a description of raid types. > > There's technically RAID0+1 and RAID1+0; one is a stripe of mirrored > drives (a RAID 0 built out of RAID 1s), the other is a mirror of two > RAID 0s. The former is much better; if you're lucky you can lose half > your drives without any data loss (if each dead drive is part of a > different mirror). Recovery is also faster. > > You'll almost certainly be much happier with hardware raid instead of > software raid. stats.distributed.net runs a 3ware controller and SATA > drives. > -- > 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?" > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >