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 [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
