Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 914BF9FA38F for ; Thu, 4 Jan 2007 14:04:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 77142-01 for ; Thu, 4 Jan 2007 14:04:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.226]) by postgresql.org (Postfix) with ESMTP id 0623D9FA354 for ; Thu, 4 Jan 2007 14:04:35 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i30so1205205wra for ; Thu, 04 Jan 2007 10:04:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GPkaBt/gAwNjtrFASzHv4AXaFNRa8ohpkD2NhVmL7ze1CsYCz2hQo/X6NcW+Adn8vTceQIrI6P9Uz48cmU98q1qvW2LBHldhU+utYJSzGQdt3nKbAMGP2iwQa2dJoX0crg2JatppU7G8EnlYI7B9Fa5rTytY6+KJrMaIUplJ4hQ= Received: by 10.90.98.10 with SMTP id v10mr318301agb.1167933875753; Thu, 04 Jan 2007 10:04:35 -0800 (PST) Received: by 10.90.84.1 with HTTP; Thu, 4 Jan 2007 10:04:35 -0800 (PST) Message-ID: Date: Thu, 4 Jan 2007 15:04:35 -0300 From: "Charles A. Landemaine" To: pgsql-performance@postgresql.org Subject: PostgreSQL to host e-mail? In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/57 X-Sequence-Number: 22658 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. I'd like to know how PostgreSQL could handle such a large amount of data. How much RAM would I need? I expect my users to have a 10GB quota per e-mail account. Thanks for your advice, -- Charles A. Landemaine.