Re: Database Loading

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Carol Walter <walterc(at)indiana(dot)edu>
Subject: Re: Database Loading
Date: 2008-02-20 09:17:48
Message-ID: 200802201017.50794.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Darren Reed 2008-02-20 09:27:52 Power outage borked things (8.1.10)...
Previous Message Rajiv Rajaian 2008-02-20 09:15:50 Re: How to create a new user with password in commandline with no prompt for password