Date: Tue, 24 Oct 2006 20:27:38 +0400 (MSD) From: Nguyen Tam Chinh <chinhngt@sectorb.msk.ru> To: Vivek Khera <vivek@khera.org> Cc: stable@freebsd.org Subject: Re: Running large DB's on FreeBSD Message-ID: <20061024202408.U923@it.hackers> In-Reply-To: <6DBE5906-CD84-44C5-AF40-FFCC78C7561E@khera.org> References: <453D49D2.1010705@rogers.com> <6DBE5906-CD84-44C5-AF40-FFCC78C7561E@khera.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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 |
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20061024202408.U923>