| 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: | Whole Thread | Raw Message | 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 |