Re: about pgsql odbc insertion efficiency is very low

Clemens Ladisch <[email protected]> Thu, 28 Nov 2019 09:37:12 +0100

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<[email protected]>

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