From owner-freebsd-amd64@FreeBSD.ORG Wed Mar 23 22:20:48 2005 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1D82316A4CE for ; Wed, 23 Mar 2005 22:20:48 +0000 (GMT) Received: from smtp-gw-cl-d.dmv.com (smtp-gw-cl-d.dmv.com [216.240.97.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id 92EF443D2D for ; Wed, 23 Mar 2005 22:20:47 +0000 (GMT) (envelope-from sven@dmv.com) Received: from lanshark.dmv.com (lanshark.dmv.com [216.240.97.46]) j2NMc3Wa090809; Wed, 23 Mar 2005 17:38:03 -0500 (EST) (envelope-from sven@dmv.com) From: Sven Willenberger To: ray@redshift.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> Content-Type: text/plain Date: Wed, 23 Mar 2005 17:20:48 -0500 Message-Id: <1111616448.10576.34.camel@lanshark.dmv.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.48 on 216.240.97.42 cc: freebsd-amd64@freebsd.org Subject: Re: amr performance woes and a bright side [UPDATE] X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Mar 2005 22:20:48 -0000 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