Rod Taylor <[EMAIL PROTECTED]> writes: > Do you happen to have any numbers comparing prepared inserts in a single > transaction against copy?
COPY is about a factor of 6 faster, it appears. I got 11.8 versus 1.87 seconds for loading the same amount of data (with the 3-column test table). So COPY's not gonna go away any time soon. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings