pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-admin@postgresql.org
Cc: Carol Walter <walterc@indiana.edu>
Subject: Re: Database Loading
Date: Wed, 20 Feb 2008 10:17:48 +0100
Message-ID: <200802201017.50794.dfontaine@hi-media.com> (raw)
In-Reply-To: <35507097-9011-408B-BC25-EA1DE8F9E205@indiana.edu>
References: <35507097-9011-408B-BC25-EA1DE8F9E205@indiana.edu>

Hi,

Le mardi 19 février 2008, Carol Walter a écrit :
> 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 
loading of a single file, which could speed up things by having several 
backends importing data at once. The implementation of this is now done and 
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 
version of it:
 http://pgloader.projects.postgresql.org/dev/
 http://pgloader.projects.postgresql.org/dev/pgloader.1.html#_parallel_loading

Regards,
-- 
dim

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (7+ messages)

Message-ID: <200802201017.50794.dfontaine@hi-media.com>
Permalink:  ../200802201017.50794.dfontaine@hi-media.com/
Also on:    postgresql.org/message-id/200802201017.50794.dfontaine@hi-media.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: dfontaine@hi-media.com, walterc@indiana.edu
  Subject: Re: Database Loading
  In-Reply-To: <200802201017.50794.dfontaine@hi-media.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox