Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl> writes:
> We have lots of trouble with using the COPY dump, so we always use de INSERT
> mode. Because the INSERT mode does'nt use transactions, this methode is very
> slow.
What would really be appreciated is some investigation into why the COPY
mode doesn't work for you. I prefer to fix problems rather than work
around them.
> This (simple) patch creates (if the -T flag is set) a transaction of every
> insert block, so de import is mostly 10 times faster.
... kinda seems like a kluge ...
regards, tom lane