On Tue, 26 Feb 2008, Tom Lane wrote:
> What are you imagining here ... a plain SQL script containing
> database-independent INSERT commands? That's going to suck compared
> to COPY no matter what.
Think 100GB+ of data that's in a CSV or delimited file. Right now the
best import path is with COPY, but it won't execute very fast as a single
process. Splitting the file manually will take a long time (time that
could be spend loading instead) and substantially increase disk usage, so
the ideal approach would figure out how to load in parallel across all
available CPUs against that single file.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD