Postgres Pro
Downloads
Home   >   mailing lists

Re: about pgsql odbc insertion efficiency is very low - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: about pgsql odbc insertion efficiency is very low
Date
Msg-id d0f06d2d-d80b-e561-49d9-b1206b44c084@ladisch.de
Whole thread Raw
In response to about pgsql odbc insertion efficiency is very low  ("HIT . man" <1141852259@qq.com>)
List pgsql-odbc
Tree view 
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

pgsql-odbc by date:

Previous
From: "HIT . man"
Date:
Subject: about pgsql odbc insertion efficiency is very low
Next
From: Christoph Berg
Date:
Subject: Re: Regression tests fail with PG12