Re: about pgsql odbc insertion efficiency is very low

HIT . man wrote:
> When I use remote PostgreSQL ODBC to insert 10 million pieces of data from the client to the server, the speed is 130
minutes.

Are you using a prepared statement?
How large are your transactions?

The fastest way to bulk load data is with COPY, which is not supported in ODBC.
To avoid network round trips, you could submit multi-row INSERT commands.


Regards,
Clemens