[Dovecot] SQL mail storage - yes yes yes!

[Timothy Martin]

On Mar 31, 2007, at 11:36am, Stephen Lee wrote:

> On Sat, 2007-03-31 at 19:30 +0200, Martin Hudec wrote:
> <snip>
>>
>> Well imagine that we have 100 users in company, each of them has 200M
>> mailbox usually filled at least to 150M. That gives us 15G  
>> database (I
>> am not counting administrative overhead like indexes etc.).
>>
>> Martin
>
> WRT size of the db, what about keeping just the message headers and
> indices in the db and the body as a file? This is akin to some content
> management systems where the file info is in a db and the content
> resides as a file. Don't know what the logistics and performance  
> issues
> are though. Clearly SQL mail storage is not for everyone.
>
> Stephen

Or the whole message, but attachments could be removed and be stored  
as files. Just as clients have the option to store headers, full  
messages, and full messages + attachments.

.tim