So what's the difference between a COPY and a batch of INSERT statements. Also, surely, fsyncs only occur at the end of a transaction, no need to fsync before a commit has been issued, right?
With COPY, the data being inserted itself does not have to pass through the postgresql parser.
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings