From: Matthew Schumacher <matt.s@aptalaska.net>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL to host e-mail?
Date: Thu, 04 Jan 2007 09:42:40 -0900
Message-ID: <459D4AA0.2090607@aptalaska.net> (raw)
In-Reply-To: <20070104120830.d002d90e.frank@wiles.org>
References: <e6575a30701041000u64d3c8c1sff6590724c264278@mail.gmail.com>
<20070104120830.d002d90e.frank@wiles.org>
Frank Wiles wrote:
> On Thu, 4 Jan 2007 15:00:05 -0300
> "Charles A. Landemaine" <landemaine@gmail.com> 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. 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.
>
I wouldn't do it this way, I would use cyrus. It stores the messages in
plain text each in it's own file (like maildir) but then it also indexes
the headers in bdb format and also can index the search database in bdb
format. The result is a very simple mail store that can perform
searches very fast. The only problem is that the search index in only
updated periodically.
If you need more information then look at the cyrus-users list as this
is WAY off topic.
schu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matt.s@aptalaska.net
Subject: Re: PostgreSQL to host e-mail?
In-Reply-To: <459D4AA0.2090607@aptalaska.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox