>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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
