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

Reply via email to