From owner-freebsd-questions@FreeBSD.ORG  Mon Jan  8 12:51:03 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id A5DFC16A403
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 12:51:03 +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 E464C13C45A
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 12:51:02 +0000 (UTC)
	(envelope-from kirk@strauser.com)
Received: from localhost (localhost [127.0.0.1])
	by kanga.honeypot.net (Postfix) with ESMTP id 08FC2209C0E
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 06:51:02 -0600 (CST)
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 dLqUwu7dolc3 for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 06:50:58 -0600 (CST)
Received: from janus.daycos.com (janus.daycos.com [10.45.12.2])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by kanga.honeypot.net (Postfix) with ESMTP id 82D0E20679F
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 06:50:58 -0600 (CST)
From: Kirk Strauser <kirk@strauser.com>
To: freebsd-questions@freebsd.org
Date: Mon, 8 Jan 2007 06:50:52 -0600
User-Agent: KMail/1.9.5
References: <200701071301.27423.kirk@strauser.com> <enrnt5$9h6$1@sea.gmane.org>
	<499c70c0701072351k114119e5kc4d9864fcc651cd7@mail.gmail.com>
In-Reply-To: <499c70c0701072351k114119e5kc4d9864fcc651cd7@mail.gmail.com>
X-Face: T+/_{qmjgbosI0J/e83I~w[&VF'w)!(<bFJWGw=Vx16yEz`z=a^@7)qZ{yc5m;
	#Q"K(=?utf-8?q?S-T=0A=09p1?=<=?utf-8?q?rTK6XRo=3F8kwsj=26g/ze=2ETkdj=24vrJ4rE=5EspYQA3/qUgm=27Ysoy=27D!?=
	=?utf-8?q?05=7CbD*W=5D+F*OPF=25=5E0=0A=09?=>(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="nextPart2353249.rpLRAPlaiy";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200701080650.56113.kirk@strauser.com>
Subject: Re: Tuning PostgreSQL for bulk imports
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 08 Jan 2007 12:51:03 -0000

--nextPart2353249.rpLRAPlaiy
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Monday 08 January 2007 1:51 am, Abdullah Al-Marrie wrote:

> Why did you choose PostgreSQL over MySQL 5.0.x?

We value our data, ruling out MyISAM.  PostgreSQL is much faster than InnoD=
B=20
for many concurrent reads and complex queries.

> Is the latest PostgreSQL release performance much better than MySQL
> 5.0.x in RELENG_6 with SMP and 2 GB of ram now?

This has been true for our workload for several years.
=2D-=20
Kirk Strauser

--nextPart2353249.rpLRAPlaiy
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----

iD8DBQBFoj4w5sRg+Y0CpvERAmxiAJ9SnE7QeC7RVXrtFxcBlJtlYoR89wCdFCN/
8aBPTBb9CJ7Sxv69ooEs6/Q=
=0Xsd
-----END PGP SIGNATURE-----

--nextPart2353249.rpLRAPlaiy--