Hi, Le dimanche 27 avril 2008, Greg Smith a écrit : > than SQL*PLUS. Then on the PostgreSQL side, you could run multiple COPY > sessions importing at once to read this data all back in, because COPY > will bottleneck at the CPU level before the disks will if you've got > reasonable storage hardware.
Latest pgloader version has been made to handle this exact case, so if you want to take this route, please consider pgloader 2.3.0: http://pgloader.projects.postgresql.org/#_parallel_loading http://pgfoundry.org/projects/pgloader/ Another good reason to consider using pgloader is when the datafile contains erroneous input lines and you don't want the COPY transaction to abort. Those error lines will get rejected out by pgloader while the correct ones will get COPYied in. Regards, -- dim
signature.asc
Description: This is a digitally signed message part.
