Re: COPY FROM STDIN instead of INSERT

>The reason why copy is faster is because it doesn't have to
>parse/plan/execute all the queries. In exchange you can't use
>expressions or joins to fill the table, only raw data.

In other words, COPY has no hidden catches, and I should go with it and don't worry. 
Correct interpretation? ;)

>Binary may be slightly faster because the datum parsing can be
>partially skipped, but that's hardly much benefit over a text copy.

I know example where it is up to three times faster.
It depends on data.

-- 
Best regards
Ilja Golshtein