Postgres Pro
Downloads
Home   >   mailing lists

COPY versus INSERT - Mailing list pgsql-general

From Jay O'Connor
Subject COPY versus INSERT
Date
Msg-id 20030513192324.C1258@altaica
Whole thread Raw
Responses Re: COPY versus INSERT  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: COPY versus INSERT  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
I'm loading a database with a lot of data from an external source (I'm
convertin all my data to postgresql)

Right now I'm just connecting to the database and issuing a whole lot of
INSERTS and this is taking longer than I had planned.

Would it be faster to just dump my database ina tab delimited format and
use a COPY FROM or psql /copy command?

Thanks

Take care,
Jay

pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Re: Serialization, Locking...implement processing Queue with a table
Next
From: "D. Dante Lorenso"
Date:
Subject: Re: Serialization, Locking...implement processing Queue with a table