Date: Sat, 30 May 2009 17:53:38 +0200 From: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net> To: freebsd-questions@freebsd.org Cc: Wojciech Puchar <wojtek@wojtek.tensor.gdynia.pl>, Johan Hendriks <Johan@double-l.nl> Subject: Re: Stable Mail Server And Web Mail Message-ID: <200905301753.38697.mel.flynn%2Bfbsd.questions@mailing.thruhere.net> In-Reply-To: <alpine.BSF.2.00.0905301731060.18381@wojtek.tensor.gdynia.pl> References: <1F9F36FCD9644D4683DADAF7DD62B412@john> <200905292225.41654.mel.flynn%2Bfbsd.questions@mailing.thruhere.net> <alpine.BSF.2.00.0905301731060.18381@wojtek.tensor.gdynia.pl>
next in thread | previous in thread | raw e-mail | index | archive | help
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. [1] 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. [1] <http://www.freebsd.org/cgi/getmsg.cgi?fetch=182581+0+/usr/local/www/db/text/2009/freebsd- hackers/20090315.freebsd-hackers> -- Mel
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200905301753.38697.mel.flynn%2Bfbsd.questions>