Importing massive amounts of data into a PostgreSQL database - Mailing list pgsql-admin

From L. Scott Loftin
Subject Importing massive amounts of data into a PostgreSQL database
Date
Msg-id NDBBINJOALBMKEHGHAIAGEMJDBAA.scott.loftin@howstuffworks.com
Whole thread Raw
List pgsql-admin
I have a 2.1 million record table to import into a newly-created Postgres
database.  On the machine I have, early calculations predict a 9.5 day
timeframe to do this.  I have dumped the data into a format that Postgres'
COPY command will handle.

Is there any other more efficient way to get massive amounts of data into a
Postgres database?

Scott


pgsql-admin by date:

Previous
From: melliani
Date:
Subject: cygwin1.dll
Next
From: "Anupam Sanghera"
Date:
Subject: Exporting database