Stable Mail Server And Web Mail
mel.flynn+fbsd.questions at mailing.thruhere.net
Sat May 30 15:53:42 UTC 2009
On Saturday 30 May 2009 17:31:35 Wojciech Puchar wrote:
> >>> It's a detailed how-to but consider the following:
> >>> a) With Oracle acquiring Sun, one should move to PostgreSQL where ever
> >>> possible.
> is this a reason, or that simply mysql is just slow and inefficient
> compared to postgreSQL?
Depends on your usage. I'd say for SMTP table lookups, MySQL can out perform
PostgreSQL, unless one uses persistent connections (postfix proxy-map to be on
topic). The reason for this is that the connection start up for MySQL has
lower overhead then for PostgreSQL. So typically with small tables (lookup
maps for transport and users are generally not in the order of millions) and
lots of connections MySQL could win. On the other hand, PostgreSQL scales
better, especially now that the Sysv IPC shared memory limit in FreeBSD has
been fixed. 
The reason for my original remark is that Oracle now acquired SAP DB, MySQL
and Berkeley DB, so the best scenario I can see is that they improve the
underused Berkeley DB table handler for MySQL and leave the rest in-tact, but
I more expect them to phase out MySQL or grow it with Oracle features, neither
of which I personally consider a good thing.
More information about the freebsd-questions