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  (Bruce Momjian <bruce@momjian.us>)
Re: Any way to speed up INSERT INTO  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OOM killer while pg_restore
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Any way to speed up INSERT INTO