Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A4B7F2E3023 for ; Mon, 28 Jan 2008 15:26:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 95978-10 for ; Mon, 28 Jan 2008 15:26:01 -0400 (AST) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153]) by postgresql.org (Postfix) with ESMTP id BEB0B2E300B for ; Mon, 28 Jan 2008 15:26:00 -0400 (AST) Received: by fg-out-1718.google.com with SMTP id 22so1830268fge.23 for ; Mon, 28 Jan 2008 11:25:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=LWeeEUZzsqeOrO60AZhnZGqAbwCZD1WT1E/uHf61V2o=; b=SmMUJ2Q0+MVLjHkvRtVFSUuqwl80OILbNjEVJHqMQn95HD2VHuRRhLbc2JoYWklLkKS020+WT88GL3vWZIyev8PGCdjMGL+u9poCLPt/uM0Fz8n60dJSkB11IThj1FwTAmaDOSR8AYkcnGmYRcsfFsfCGbY0LKNLaQRchv+1ecw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=v7lAU8l6GUivykci2gg8TlDcsfuCVpFIdm014QS/m9p77+6MsXYyFLvnN0tWEZ6JivWch9fapi9duY6XC6BVQg6OS4DNOdZwz1sl3jac3v3MdnR5b9kOBbw0r6dNIHQ+Iyho1qso7pBM68MmgFnc/SCksutw1UqUuLxWiCZMagM= Received: by 10.86.99.9 with SMTP id w9mr5569149fgb.22.1201548359333; Mon, 28 Jan 2008 11:25:59 -0800 (PST) Received: by 10.86.72.12 with HTTP; Mon, 28 Jan 2008 11:25:59 -0800 (PST) Message-ID: <285fb20801281125k641902feo8d74b1c68640d94b@mail.gmail.com> Date: Mon, 28 Jan 2008 20:25:59 +0100 From: "Christian Nicolaisen" To: pgsql-performance@postgresql.org Subject: 8x2.5" or 6x3.5" disks MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7858_17902944.1201548359334" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/274 X-Sequence-Number: 28513 ------=_Part_7858_17902944.1201548359334 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi We are looking to buy a new server and I am wondering what kind of hardware we should buy and how to configure it. We are either getting 8x 2.5" 15k rpm sas disks or 6x 3.5" 15k rpm sas disks. If we go with the 2.5" disks I think we should run 6 disks in raid 10 for the database and 2 disks in raid 1 for os/wal If we go with the 3.5" disks I think we should run 4 disks in raid 10 for the database and 2 disks in raid 1 for os/wal The database has currently about 40gb data and 20gb indexes. The work consists mainly of small transactions, with the occasional report. Currently we have 10gb ram, which is enough to hold the working set in memory 99% of the time. The database server will only be running postgres, nothing else. So, my question is: should I go for the 2.5" disk setup or 3.5" disk setup, and does the raid setup in either case look correct? ------=_Part_7858_17902944.1201548359334 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi

We are looking to buy a new server and I am wondering what kind of hardware we should buy and how to configure it.

We are either getting 8x 2.5" 15k rpm sas disks or 6x 3.5" 15k rpm sas disks.
If we go with the 2.5" disks I think we should run 6 disks in raid 10 for the database and 2 disks in raid 1 for os/wal
If we go with the 3.5" disks I think we should run 4 disks in raid 10 for the database and 2 disks in raid 1 for os/wal

The database has currently about 40gb data and 20gb indexes. The work consists mainly of small transactions, with
the occasional report. Currently we have 10gb ram, which is enough to hold the working set in memory 99% of the time.
The database server will only be running postgres, nothing else.

So, my question is: should I go for the 2.5" disk setup or 3.5" disk setup, and does the raid setup in either case look correct?
------=_Part_7858_17902944.1201548359334--