Any way to speed up INSERT INTO

Поиск
Список
Период
Сортировка
От aditya desai
Тема Any way to speed up INSERT INTO
Дата
Msg-id CAN0SRDHkd=3j7_xu2G_mg0ku0uwdN+DDGxEn8gzO=9hb=UFtcw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Any way to speed up INSERT INTO
Re: Any way to speed up INSERT INTO
Список pgsql-performance
Hi,
One of the service layer app is inserting Millions of records in a table but one row at a time. Although COPY is the fastest way to import a file in a table. Application has a requirement of processing a row and inserting it into a table. Is there any way this INSERT can be tuned by increasing parameters? It is taking almost 10 hours for just 2.2 million rows in a table. Table does not have any indexes or triggers.

Regards,
Aditya.

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