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 38596D7061 for ; Wed, 16 Nov 2005 17:50:20 -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 55933-07 for ; Wed, 16 Nov 2005 21:50:21 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by svr1.postgresql.org (Postfix) with ESMTP id A2217D6853 for ; Wed, 16 Nov 2005 17:50:17 -0400 (AST) Received: by zproxy.gmail.com with SMTP id z3so1522319nzf for ; Wed, 16 Nov 2005 13:50:19 -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=rCEIW+23z9LTiVtRKoN3nfjvAtYxqcYJaLpCNTL0fUSTSBBJ3eV3RciZ5fT+YcMuzR7VSTMYe4HrgkzeZ2+S+e/9reff5bB4PiBHgDK7TOJ/TRzKG1fJgEJ5A46+D4kR9dH7oryXiKeCSBzMXYl9pPqT4DoFXOw82NZgCcM4gFA= Received: by 10.64.142.16 with SMTP id p16mr1307149qbd; Wed, 16 Nov 2005 13:50:19 -0800 (PST) Received: by 10.65.192.16 with HTTP; Wed, 16 Nov 2005 13:50:19 -0800 (PST) Message-ID: Date: Wed, 16 Nov 2005 22:50:19 +0100 From: Claus Guttesen To: Vivek Khera Subject: Re: Hardware/OS recommendations for large databases (5TB) Cc: Postgresql Performance In-Reply-To: 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/304 X-Sequence-Number: 15561 > at 5TB data, i'd vote that the application is disk I/O bound, and the > difference in CPU speed at the level of dual opteron vs. dual-core > opteron is not gonna be noticed. > > to maximize disk, try getting a dedicated high-end disk system like > nstor or netapp file servers hooked up to fiber channel, then use a > good high-end fiber channel controller like one from LSI. > > and go with FreeBSD amd64 port. It is *way* fast, especially the > FreeBSD 6.0 disk system. I'm (also) FreeBSD-biased but I'm not shure whether the 5 TB fs will work so well if tools like fsck are needed. Gvinum could be one option but I don't have any experience in that area. regards Claus