From owner-freebsd-stable@FreeBSD.ORG Tue Oct 24 16:27:44 2006 Return-Path: X-Original-To: stable@freebsd.org Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EA3CB16A49E for ; Tue, 24 Oct 2006 16:27:44 +0000 (UTC) (envelope-from chinhngt@sectorb.msk.ru) Received: from hq.sectorb.msk.ru (petaflop.b.gz.ru [194.88.210.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6DBDE43DA2 for ; Tue, 24 Oct 2006 16:27:34 +0000 (GMT) (envelope-from chinhngt@sectorb.msk.ru) Received: from it.local (it.local [172.16.20.8]) by hq.sectorb.msk.ru (Postfix) with ESMTP id 753F923F9; Tue, 24 Oct 2006 20:27:19 +0400 (MSD) Date: Tue, 24 Oct 2006 20:27:38 +0400 (MSD) From: Nguyen Tam Chinh X-X-Sender: chinhngt@it.hackers To: Vivek Khera In-Reply-To: <6DBE5906-CD84-44C5-AF40-FFCC78C7561E@khera.org> Message-ID: <20061024202408.U923@it.hackers> References: <453D49D2.1010705@rogers.com> <6DBE5906-CD84-44C5-AF40-FFCC78C7561E@khera.org> X-Operating-System: FreeBSD 6-STABLE Keywords: 216091683 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: stable@freebsd.org Subject: Re: Running large DB's on FreeBSD X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Oct 2006 16:27:45 -0000 On Tue, 24 Oct 2006, Vivek Khera wrote: > > On Oct 23, 2006, at 7:01 PM, Mike Jakubik wrote: > >> So, first of all, am i crazy for choosing fbsd+mysql for this rather than >> something like Solaris + Oracle? :) Secondly, i am just looking for some >> suggestions, opinions, success/failure story's that may help me out. Is >> anyone out there using FreeBSD for something of this size? I am hoping that >> everything > > Take a good look at postgres. In the end, it really depends on your workload > and how much truly relational qork you're expecting the DB to do. If all > you're using the DB for is a file store, you might as well use mysql, but > then you have to worry about all of your data integrity in your application. > Personally, I prefer to put that burden on the DB engine. > > The size of your DB is not all that large. There are people running terabyte > DB's under postgres. Our big DB is around 60Gb with hundreds of millions of > rows spread across dozens of tables which are regularly joined with each > other for reports. It is pounded on 24x7 with lots and lots of inserts, > updates, and selects going on all the time. > Could you share with us your servers' hardware specifics and configuration (tuning) of PostgreSQL? This would help many in making decision. ----- With best regards, | The Power to Serve Nguyen Tam Chinh | http://www.FreeBSD.org Loc: sp.cs.msu.su |