Re: about pgsql odbc insertion efficiency is very low

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: about pgsql odbc insertion efficiency is very low
Date: 2019-11-28 08:37:12
Message-ID: d0f06d2d-d80b-e561-49d9-b1206b44c084@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Christoph Berg 2019-12-10 10:26:04 Re: Regression tests fail with PG12
Previous Message HIT . man 2019-11-28 06:53:34 about pgsql odbc insertion efficiency is very low