Stefan Kaltenbrunner < stefan@kaltenbrunner.cc> writes: > Tom Lane wrote: >> A more interesting question is what sort of hardware you need for that >> actually to be a win, though. Loading a few tables in parallel sounds >> like an ideal recipe for oversaturating your disk bandwidth...
> you don't actually need that much of disk bandwidth both COPY and CREATE > INDEX are CPU bottlenecked on modern boxes and reasonable disk > subsystems - spreading their work over multiple cores/processes can give > big benefits.
Hmm ... I wonder if that's true for COPY BINARY ...
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster