X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E6F6D9FB2C4 for ; Fri, 8 Sep 2006 07:01:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 90796-05-2 for ; Fri, 8 Sep 2006 10:01:42 +0000 (UTC) X-Greylist: delayed 00:27:00.279014 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 156659FB33B for ; Fri, 8 Sep 2006 07:00:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from gate.criticalsoftware.com (gate.criticalsoftware.com [212.13.37.242]) by svr4.postgresql.org (Postfix) with ESMTP id A39F05AF888 for ; Fri, 8 Sep 2006 09:33:01 +0000 (GMT) Received: by gate.criticalsoftware.com (Postfix, from userid 102) id 56D203A63F; Fri, 8 Sep 2006 10:29:33 +0100 (WEST) Received: from [192.168.2.70] (unknown [192.168.2.70]) by gate.criticalsoftware.com (Postfix) with ESMTP id AE4753B379; Fri, 8 Sep 2006 09:29:32 +0000 (UTC) Message-ID: <4501384C.4000506@criticalsoftware.com> Date: Fri, 08 Sep 2006 10:30:52 +0100 From: Nuno Alexandre Alves User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Performance in a 7 TB database. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Copyrighted-Material: Please visit http://www.criticalsoftware.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/43 X-Sequence-Number: 20729 Hi, I have a customer who wants a database solution for a 7 TB database. Insert will be the main action in the database. There are some case studies with detail information about performance and hardware solution on this database size? What are the minimum hardware requirements for this kind of database? Thanks is advance, Nuno DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the individual(s) named. If you are not a named addressee and mistakenly received this message you should not copy or otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. Therefore, the sender does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard copy version if verification is required. Critical Software, SA.