Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B67772E0082 for ; Fri, 28 Mar 2008 07:04:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69700-01-3 for ; Fri, 28 Mar 2008 07:04:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ag-out-0708.google.com (ag-out-0708.google.com [72.14.246.248]) by postgresql.org (Postfix) with ESMTP id 56FF02E0031 for ; Fri, 28 Mar 2008 07:03:55 -0300 (ADT) Received: by ag-out-0708.google.com with SMTP id 23so9619897agd.5 for ; Fri, 28 Mar 2008 03:03:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=KXHscKlBpmj+y2KAllKx2KyNRcVxSRqigOJUvEKlU5o=; b=REh+pLznxo/6J0a6ipKwAHKY5dLgVguUUkHD32UMG1SsLlFFd4MAPr+EgwQGrZKTCs063XVMKCCLVzoCQUBWMRt6WIHjEbDo+XV93gGmF4Wlfq/oG8dIiNV4WcRyi3puio+7xewQGWXG4XywEfPk3Hs5YYsNAdFXOvtLbRxJxQ0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=rTwQHjXibN9GnKS6Dmok7SA2V3JfhBCMpEtbQ8XdRgsIzJE+66XpURvbfdvnIBVexkOa3I9U/BS1Qf1tc3xpPxEo9/DtPAAXWFWS8jqzchRWs+dNqk5U/3Npz6Ju9eIPJe18PourG3aCulEIUxs/AP5O0h9kMAaqPM1xLnI/+XM= Received: by 10.100.216.3 with SMTP id o3mr4855340ang.62.1206698629665; Fri, 28 Mar 2008 03:03:49 -0700 (PDT) Received: by 10.100.228.15 with HTTP; Fri, 28 Mar 2008 03:03:49 -0700 (PDT) Message-ID: Date: Fri, 28 Mar 2008 11:03:49 +0100 From: "Claus Guttesen" To: "Laszlo Nagy" Subject: Re: Planning a new server - help needed Cc: pgsql-performance@postgresql.org, "Tony Nagy" In-Reply-To: <47ECB4F6.1040901@shopzeus.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47ECB4F6.1040901@shopzeus.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/512 X-Sequence-Number: 29466 > I need to install a new server for postgresql 8.3. It will run two > databases, web server and some background programs. We already have a > server but it is becoming slow and we would like to have something that > is faster. It is a cost sensitive application, and I would like to get > your opinion in some questions. > > The database itself is an OLTP system. There are many smaller tables, > and some bigger ones (biggest table with 1.2 million records, table size > 966MB, indexes size 790MB). In the bigger tables there are only a few > records updated frequently, most of the other records are not changed. > The smaller tables are updated continuously. > > Question 1. We are going to use PostgreSQL 3.1 with FreeBSD. The pg docs > say that it is better to use FreeBSD because it can alter the I/O > priority of processes dynamically. The latest legacy release is 6.3 > which is probably more stable. However, folks say that 7.0 has superior > performance on the same hardware. Can I use 7.0 on a production server? I guess you mean postgresql 8.3.1? :-) I use FreeBSD 7 release on a 8-way HP DL360 G5 with a ciss controller. Works out of the box and I haven't had any issue with 7.0 at all. > Question 2. SCSI or SATA? I plan to buy a RocketRAID 3520 controller > with 8 SATA 2 disks. The operating system would be on another disk pair, > connected to the motherboard's controller. I wonder if I can get more > performance with SCSI, for the same amount of money? (I can spend about > $1500 on the controller and the disks, that would cover 10 SATA 2 disks > and the controller.) SAS would probably be the way to go. I haven't tried the rocketraid-controller. I use the built-in p400i-controller on my servers using the ciss-driver. I've heard many positive remarks about areca. > Question 3. FreeBSD 7.0 can use the ZFS file system. I suspect that UFS > 2 + soft updates will be better, but I'm not sure. Which is better? I'd stick with ufs2 atm. There are some issues with zfs which probably have been ironed out by now but ufs2 has been deployed for a longer time. Performance-wise they are about the same. > Question 4. How to make the partitions? This is the hardest question. > Here is my plan: > > - the OS resides on 2 disks, RAID 1 > - the databases should go on 8 disks, RAID 0 + 1 If you have enough disks raid-6 should perform almost as good as raid 1+0. I've setup 11 disks in raid-6 plus one hotspare so I can get more space out of it. "Enough disks" are approx. eight and up. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare