| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | aditya desai <admad123(at)gmail(dot)com> |
| Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Any way to speed up INSERT INTO |
| Date: | 2022-03-04 18:38:51 |
| Message-ID: | YiJcu8xuAHvJywzB@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, Mar 5, 2022 at 12:01:52AM +0530, aditya desai wrote:
> 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.
Well, sections 14.4 and 14.5 might help:
https://www.postgresql.org/docs/14/performance-tips.html
Your time seems very slow --- are the rows very wide?
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-03-04 18:42:39 | Re: Any way to speed up INSERT INTO |
| Previous Message | aditya desai | 2022-03-04 18:31:52 | Any way to speed up INSERT INTO |