From owner-freebsd-stable@FreeBSD.ORG Wed Oct 25 18:00:08 2006 Return-Path: X-Original-To: freebsd-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 F12C016A403 for ; Wed, 25 Oct 2006 18:00:08 +0000 (UTC) (envelope-from kirk@strauser.com) Received: from kanga.honeypot.net (kanga.honeypot.net [208.162.254.122]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1201E43D53 for ; Wed, 25 Oct 2006 18:00:06 +0000 (GMT) (envelope-from kirk@strauser.com) Received: from localhost (localhost [127.0.0.1]) by kanga.honeypot.net (Postfix) with ESMTP id 310D99639B for ; Wed, 25 Oct 2006 13:00:06 -0500 (CDT) X-Virus-Scanned: amavisd-new at honeypot.net Received: from kanga.honeypot.net ([127.0.0.1]) by localhost (kanga.honeypot.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ao0hucrRVWlq for ; Wed, 25 Oct 2006 13:00:03 -0500 (CDT) Received: from janus.daycos.com (outbound.daycos.com [204.26.70.70]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by kanga.honeypot.net (Postfix) with ESMTP id 9C9AD95B7D for ; Wed, 25 Oct 2006 13:00:02 -0500 (CDT) From: Kirk Strauser To: freebsd-stable@freebsd.org Date: Wed, 25 Oct 2006 12:59:53 -0500 User-Agent: KMail/1.9.4 References: <453D49D2.1010705@rogers.com> In-Reply-To: <453D49D2.1010705@rogers.com> X-Face: T+/_{qmjgbosI0J/e83I~w[&VF'w)!((xEpj///^bA/6?jHHS?nq+T8_+`nh"WnEWCWG, \}]Y2$)) =?utf-8?q?vLVz4ACChrEcb=7DCO=5EtYmMG=5C=0A=09ts=2Em=3F=5B7=5B6OwE*dAJ*9f+m?= =?utf-8?q?X=2E7R32qeN=5EDJ=5C?=(k@evW?IRQCy.^ MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2345726.YaB8Z5l6Dc"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200610251259.57388.kirk@strauser.com> 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: Wed, 25 Oct 2006 18:00:09 -0000 --nextPart2345726.YaB8Z5l6Dc Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Monday 23 October 2006 6:01 pm, Mike Jakubik wrote: > I'm not exactly informed as to the specific workload yet, however i know > the database will have several million rows and be larger than 10GB. No offense, but that's a pretty small database. Also, IMHO the crazy part= =20 is using MySQL over PostgreSQL. It's hardly any faster, and you have to do= =20 a *lot* of client-side work to emulate PostgreSQL's built-in functions. =20 Unless you use the much slower InnoDB that's now owned by Oracle, in which= =20 case MySQL gets most of those features (but is no faster than PostgreSQL=20 would be). =2D-=20 Kirk Strauser --nextPart2345726.YaB8Z5l6Dc Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- iD8DBQBFP6Yd5sRg+Y0CpvERAukxAKCVHPCSSieEfO08BnC/Gk0GqWiXYACglU1t xTyEouzIx4KljXLINVrqC2w= =sl4/ -----END PGP SIGNATURE----- --nextPart2345726.YaB8Z5l6Dc--