> This is very interesting. Would you mind writing a README.postgresql > with this (and possibly more) information for tuning > PostgreSQL for DbMail?
I wouldn't mind at all. However if there is someone that feels they may be more qualified, then by all means step in. I'm still pretty new to dbmail although we are running it on an install with about 1000 pop/IMAP users and 150,000 forwarding accounts (we give out free forwarding). Most of what we've learned thus far has been through trial and error, and even though I always search the list archives when I have a problem, it just kinda seems like we don't have many Postgres users out there. I'll whip together something though within the next week just sorta documenting the things we've run across so far, and then let everyone have their way with it. And I am more than glad to help - I think the reason why Open Source works as well as it does is exactly because of things like this (people contributing where they can). I would also love to pour through all the SQL code at some point in the future and see how it can be better optimized. Much of what I've seen already is very MySQL specific, and Postgres should in theory be the better performer (on bigger installs) due to it's MVCC (versioning system as opposed to locking tables like MySQL does). ----- "Any sufficiently advanced bug is indistinguishable from a feature." -- Rich Kulawiec [EMAIL PROTECTED]
