about pgsql odbc insertion efficiency is very low

Поиск
Список
Период
Сортировка
От HIT . man
Тема about pgsql odbc insertion efficiency is very low
Дата
Msg-id tencent_387CB4259BAD638D9B38BBE112B98DD3D10A@qq.com
обсуждение исходный текст
Ответы Re: about pgsql odbc insertion efficiency is very low  (Clemens Ladisch <clemens@ladisch.de>)
Список 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


   







Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: pgsql-odbc Installation problem
Следующее
От: Clemens Ladisch
Дата:
Сообщение: Re: about pgsql odbc insertion efficiency is very low