Re: COPY FROM STDIN instead of INSERT

Hello!

>Using COPY FROM STDIN is much faster than INSERT's (I am sure some out
>there have test times to compare, I don't have any on hand)

Yes, I know it is much faster.

The question is about possible pay for this quickness.

What if COPY, say, locks index until end of transaction (it is just an example, of course)? Such things are not so easy to discover during design or even test time.

>Sounds like your working with an existing database - if you are starting
>from scratch (inserting data into an empty database) then there are
>other things that can help too.

I am working with existing database, though I am interested what "other things" you mean.

Many thanks.

--
Best regards
Ilja Golshtein