Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DA7972E0053 for ; Wed, 20 Feb 2008 05:18:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87654-09 for ; Wed, 20 Feb 2008 05:17:55 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id 4EAB82E004F for ; Wed, 20 Feb 2008 05:17:59 -0400 (AST) Received: from dim (gut75-1-81-57-27-121.fbx.proxad.net [81.57.27.121]) by hi-media.com (Postfix) with ESMTP id 9409E1880DC; Wed, 20 Feb 2008 10:15:01 +0100 (CET) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-admin@postgresql.org Subject: Re: Database Loading Date: Wed, 20 Feb 2008 10:17:48 +0100 User-Agent: KMail/1.9.7 Cc: Carol Walter References: <35507097-9011-408B-BC25-EA1DE8F9E205@indiana.edu> In-Reply-To: <35507097-9011-408B-BC25-EA1DE8F9E205@indiana.edu> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1761489.Rqz8kCCZGI"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802201017.50794.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/226 X-Sequence-Number: 28300 --nextPart1761489.Rqz8kCCZGI Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Le mardi 19 f=E9vrier 2008, Carol Walter a =E9crit=A0: > I have to load a very large database. Is there a command that can > load data in bulk faster than the copy command does? The next version of pgloader has been asked to implement some new parallel= =20 loading of a single file, which could speed up things by having several=20 backends importing data at once. The implementation of this is now done and= =20 ready to get some tests, but still at a beta or release candidate status. If you want to try it (and report about your tests?), here's the current=20 version of it: http://pgloader.projects.postgresql.org/dev/ http://pgloader.projects.postgresql.org/dev/pgloader.1.html#_parallel_load= ing Regards, =2D-=20 dim --nextPart1761489.Rqz8kCCZGI Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHu/A+lBXRlnbh1bkRAsLqAJ9nRxEBDcTk508fUDHdA/K/+/kH4QCfXEC5 Rg8wOEBaDjvO592ohof0rlk= =0uZu -----END PGP SIGNATURE----- --nextPart1761489.Rqz8kCCZGI--