Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6F04F1337B82 for ; Sun, 6 Feb 2011 15:24:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 00478-08 for ; Sun, 6 Feb 2011 19:24:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from 31.mail-out.ovh.net (31.mail-out.ovh.net [213.186.62.10]) by mail.postgresql.org (Postfix) with SMTP id D3DD51337B34 for ; Sun, 6 Feb 2011 15:24:51 -0400 (AST) Received: (qmail 23200 invoked by uid 503); 6 Feb 2011 20:03:35 -0000 Received: from b7.ovh.net (HELO mail97.ha.ovh.net) (213.186.33.57) by 31.mail-out.ovh.net with SMTP; 6 Feb 2011 20:03:35 -0000 Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 6 Feb 2011 21:24:51 +0200 Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13) (lists%peufeu.com@88.161.102.87) by ns0.ovh.net with SMTP; 6 Feb 2011 21:24:49 +0200 Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes To: pgsql-performance@postgresql.org, Linos Subject: Re: general hardware advice References: <4D4EE577.9060803@linos.es> Date: Sun, 06 Feb 2011 20:24:49 +0100 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Pierre C" Message-ID: In-Reply-To: <4D4EE577.9060803@linos.es> User-Agent: Opera Mail/10.63 (Linux) X-Ovh-Tracer-Id: 17690420811766040113 X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|U 0.5/N X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201102/261 X-Sequence-Number: 42399 On Sun, 06 Feb 2011 19:16:23 +0100, Linos wrote: > I am searching what would be the best hardware combination to a new > server i have to install, the new server will have a Postgresql 9.0 with > a database of about 10gb, the database part it is not the problem for > me, in this size almost, the part where i am a bit lost is that i have > to share from the same server about 20TB of data with samba or ISCSI (i > have to test both ways to share when i have the hardware) because this > is to be the file-server of 8 Avid video workstations. What is the expected load on the postgresql instance ? Also, for multiple high throughput concurrent streams (as in AVID), filesystem choice is critical.