Date: Wed, 23 Mar 2005 17:20:48 -0500 From: Sven Willenberger <sven@dmv.com> To: ray@redshift.com Cc: freebsd-amd64@freebsd.org Subject: Re: amr performance woes and a bright side [UPDATE] Message-ID: <1111616448.10576.34.camel@lanshark.dmv.com> In-Reply-To: <3.0.1.32.20050323140104.00a76cb8@pop.redshift.com> References: <1110895353.4291.16.camel@lanshark.dmv.com> <1110847561.3412.38.camel@lanshark.dmv.com> <1110895353.4291.16.camel@lanshark.dmv.com> <3.0.1.32.20050323140104.00a76cb8@pop.redshift.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 2005-03-23 at 14:01 -0800, ray@redshift.com wrote: > | At any rate, I am glad I can stay with the FreeBSD option now. > | > | Sven > > Hi Sven, > > I was following along with your e-mail there - is there any reason you are > using postgress over MySQL? I use FreeBSD with MySQL here and have very good > luck with it. I did use postgress years ago, but moved to MySQL and had better > luck. > > Also, in your testing, are you using a generic FreeBSD kernel or have you done > any tuning, tweaking to it and/or the OS settings? > > I recently completed some tweaking with FreeBSD/apache and PHP and from start > to finish, ended up with a 750% increase in TPS. So tweaking and fine tuning > (and being open to changing apps/versions of software) can have a big impact. > > Thanks! > > Ray We are using PostgreSQL for its stored procedures, stability, SQL-compliance, and ability to handle 100G+ tables without flinching. It has been only recently that mysql has even added subqueries much less the higher functionality that we are seeking from a database; after evaluation, PostgreSQL was the enterprise-grade solution that we were seeking, and, with proper tweaking, does perform quite well. After one too many experiences with corrupt mysql tables, workarounds to implementing basic SQL compliant queries, and seeming lack of functionality, the switch to PostgreSQL was almost a no-brainer. Not trying to get into a db shootout as each system has its merits and drawbacks; for what we needed, PostgreSQL provided the solution. I am running a modified kernel that adds plenty of memory for use by the shared memory system PostgreSQL enjoys. Sven
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1111616448.10576.34.camel>