X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 71271D7E67 for ; Tue, 15 Nov 2005 04:28:34 -0400 (AST) 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 93211-02 for ; Tue, 15 Nov 2005 08:28:34 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196]) by svr1.postgresql.org (Postfix) with ESMTP id 9EE35D6D8C for ; Tue, 15 Nov 2005 04:28:29 -0400 (AST) Received: by zproxy.gmail.com with SMTP id m7so1901779nzf for ; Tue, 15 Nov 2005 00:28:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UIKFEHWvVTKobTTlHA+0tXlOXSDmey1yoVjTjabopG3xDNXSJMB/ieRpw7X/IgepSIgVWXohYMA/ixFQ6/g82/OOs0i4f99OyXjy52yJYz2sXqyCCFkBaJ4jlPfdjVu+QHAbhagAfkL4yWnddWt5u4yi7HHdnYMMr4BfWFIAQnA= Received: by 10.64.179.4 with SMTP id b4mr6457895qbf; Tue, 15 Nov 2005 00:28:30 -0800 (PST) Received: by 10.65.192.16 with HTTP; Tue, 15 Nov 2005 00:28:30 -0800 (PST) Message-ID: Date: Tue, 15 Nov 2005 09:28:30 +0100 From: Claus Guttesen To: Adam Weisberg Subject: Re: Hardware/OS recommendations for large databases (5TB) Cc: pgsql-performance@postgresql.org In-Reply-To: <1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1B80C974ABFB23429A403B6667FE84C71066E8@seiumain.SEIU.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/239 X-Sequence-Number: 15496 > Does anyone have recommendations for hardware and/or OS to work with arou= nd > 5TB datasets? Hardware-wise I'd say dual core opterons. One dual-core-opteron performs better than two single-core at the same speed. Tyan makes some boards that have four sockets, thereby giving you 8 cpu's (if you need that many). Sun and HP also makes nice hardware although the Tyan board is more competetive priced. OS wise I would choose the FreeBSD amd64 port but partititions larger than 2 TB needs some special care, using gpt rather than disklabel etc., tools like fsck may not be able to completely check partitions larger than 2 TB. Linux or Solaris with either LVM or Veritas FS sounds like candidates. > I have been working with datasets no bigger than around 30GB, and that (I= 'm > afraid to admit) has been in MSSQL. Well, our data are just below 30 GB so I can't help you there :-) regards Claus