Re: COPY versus INSERT

"Jay O'Connor" <joconnor@cybermesa.com> writes:

> 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?

Most definitely--the SQL parser and planner have to be run for each
INSERT.  The parsing done by COPY is much simpler.

-Doug