From: | HIT (dot) man <1141852259(at)qq(dot)com> |
---|---|
To: | pgsql-odbc <pgsql-odbc(at)postgresql(dot)org> |
Subject: | about pgsql odbc insertion efficiency is very low |
Date: | 2019-11-28 06:53:34 |
Message-ID: | tencent_387CB4259BAD638D9B38BBE112B98DD3D10A@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello authors
I'm sorry email to you may you are in busy. When using PostgreSQL ODBC, I can't improve the speed of inserting into the database. could you give me some guidance in using postgresql odbc driver.
The details are as follows.When I use remote PostgreSQL ODBC to insert 10 million pieces of data from the client to the server, the speed is 130 minutes. I How can I improve my speed.
This is a screenshot of my ODBC configuration.I used PostgreSQL ODBC version 11.01 X86 .
Could you give me some suggestions to improve the insertion performance optimization. I will be very grateful
Looking forward to hearing from you
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2019-11-28 08:37:12 | Re: about pgsql odbc insertion efficiency is very low |
Previous Message | Inoue, Hiroshi | 2019-11-27 12:45:50 | Re: pgsql-odbc Installation problem |