COPY versus INSERT

From: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY versus INSERT
Date: 2003-05-14 02:23:24
Message-ID: 20030513192324.C1258@altaica
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-05-14 02:32:34 Re: executables when upgrading
Previous Message Jay O'Connor 2003-05-14 02:21:08 Re: executables when upgrading