1001 Apologies for the "misleading" info. I hadn't read earlier posts? What are the benefits on performance for storing mail on a db? --- On Wed, 5/27/09, Steve Muchai <smuchai@gmail.com> wrote: From: Steve Muchai <smuchai@gmail.com> Subject: Re: [Skunkworks] Postfix maildir. To: "Skunkworks forum" <skunkworks@lists.my.co.ke> Date: Wednesday, May 27, 2009, 11:14 PM On Wed, May 27, 2009 at 9:39 PM, Broken Maize <brokenmaize@yahoo.com> wrote:
On Postfix setup thread. First of all, there is no such thing as storing mail in a database -mysql or
Actually there is. Lots of proprietary systems store mail in databases. Even some open-source: look at http://search.cpan.org/~rjbs/Email-Store-0.255/lib/Email/Store.pm.
otherwise. The only stuff that would go into the database would be user credentials.
Agreed, IMHO only user credentials should go into the database, plus other stuff like location of mailbox, status of account (enabled/disabled/vacation etc), quota details..... which is why I asked what's the reasoning behind wanting to store the actual messages in a database.
Secondly for performance use the "maildir" format, which supports indexing and hence scales well with speed of retrieving mail, indexing the mailboxes, etc. The alternative "mbox" format stores all mail in a single file, and this does not scale well. Enjoy!
Totally agreed. Maildir works great, mbox doesn't scale well and is plagued with file locking issues. Regards, Steve -- "A democracy is a sheep and two wolves deciding on what to have for lunch. Freedom is a well armed sheep contesting the results of the decision." - Stolen from someone else's sig. _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general