From owner-freebsd-questions@FreeBSD.ORG  Mon Jan  8 17:11:07 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 DDBCE16A407
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 17:11:07 +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 9C01C13C44C
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 17:11:07 +0000 (UTC)
	(envelope-from kirk@strauser.com)
Received: from localhost (localhost [127.0.0.1])
	by kanga.honeypot.net (Postfix) with ESMTP id C5D8A20A570
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 11:11:06 -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 CBc-+HcqGE8g for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 11:11:04 -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 BA8EA206215
	for <freebsd-questions@freebsd.org>;
	Mon,  8 Jan 2007 11:11:03 -0600 (CST)
From: Kirk Strauser <kirk@strauser.com>
To: freebsd-questions@freebsd.org
Date: Mon, 8 Jan 2007 11:10:57 -0600
User-Agent: KMail/1.9.5
References: <20070108150544.11006.qmail@simone.iecc.com>
In-Reply-To: <20070108150544.11006.qmail@simone.iecc.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="nextPart2162554.XGHC2GeoXp";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200701081111.01673.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 17:11:07 -0000

--nextPart2162554.XGHC2GeoXp
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Monday 08 January 2007 9:05 am, John Levine wrote:
> >> Why did you choose PostgreSQL over MySQL 5.0.x?
> >
> >We value our data, ruling out MyISAM.
>
> Huh?  I thought you said that the SQL database is just a mirror of the
> stuff from Foxpro.

Not *all* of it.  We're migrating over to it as the native backend for new=
=20
applications, so the Foxpro stuff is loaded into its own schema inside the=
=20
same database as the production data.
=2D-=20
Kirk Strauser

--nextPart2162554.XGHC2GeoXp
Content-Type: application/pgp-signature

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

iD8DBQBFonsl5sRg+Y0CpvERApuUAJ9hocOy7eI9/aEtys5p5g+qobybnACgiZw9
/gMMC9JRKqeykRdKzwWNIwE=
=4BF9
-----END PGP SIGNATURE-----

--nextPart2162554.XGHC2GeoXp--