Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DF4EB9F938C for ; Thu, 4 Jan 2007 14:12:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 39767-09 for ; Thu, 4 Jan 2007 14:11:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (unknown [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 3BA729FA4EE for ; Thu, 4 Jan 2007 14:11:50 -0400 (AST) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l04IBglY021821 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 4 Jan 2007 10:11:47 -0800 Subject: Re: PostgreSQL to host e-mail? From: "Joshua D. Drake" To: "Charles A. Landemaine" Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Command Prompt, Inc. Date: Thu, 04 Jan 2007 10:11:45 -0800 Message-Id: <1167934305.18376.15.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 04 Jan 2007 10:11:49 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/58 X-Sequence-Number: 22659 On Thu, 2007-01-04 at 15:00 -0300, Charles A. Landemaine wrote: > I'm building an e-mail service that has two requirements: It should > index messages on the fly to have lightening search results, and it > should be able to handle large amounts of space. The server is going > to be dedicated only for e-mail with 250GB of storage in Raid-5. Well Raid 5 is likely a mistake. Consider RAID 10. > I'd > like to know how PostgreSQL could handle such a large amount of data. 250GB is not really that much data for PostgreSQL I have customers with much larger data sets. > How much RAM would I need? Lots... which is about all I can tell you without more information. How many customers? Are you using table partitioning? How will you be searching? Full text or regex? Joshua D. Drake > I expect my users to have a 10GB quota per > e-mail account. > Thanks for your advice, > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate