"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> IMO the place to start is COPY which is per my tests, slow. Multi
> worker connection restore is great and I have proven that with some
> work it can provide o.k. results but it is certainly not acceptable.
It was already pointed out to you that we can hope for only incremental
speedups in COPY per se. Don't be too quick to dismiss the discussion
of large-grain parallelism, because I don't see anything else within
reach that might give integer multiples rather than percentage points.
regards, tom lane