Re: Any way to speed up INSERT INTO

Hi Bruce,
Correct rows are wider. One of the columns is text and one is bytea.

Regards,
Aditya.

On Sat, Mar 5, 2022 at 12:08 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> 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.
>
>