Ok, thanks -- Sent from Mail.ru app for Android Wednesday, 24 November 2021, 11:28pm +03:00 from Godfrin, Philippe E [email protected] :
>The notion of COPY blocks and asynchronously is very interesting > >From: Gavin Roy < [email protected]> >Sent: Wednesday, November 24, 2021 1:50 PM >To: Godfrin, Philippe E < [email protected]> >Cc: [email protected] >Subject: [EXTERNAL] Re: Inserts and bad performance > > > > >On Wed, Nov 24, 2021 at 2:15 PM Godfrin, Philippe E < >[email protected]> wrote: >>Greetings >>I am inserting a large number of rows, 5,10, 15 million. The python code >>commits every 5000 inserts. The table has partitioned children. > >On the Python client side, if you're using psycopg, you should consider using >using COPY instead of INSERT if you're not: > >https://www.psycopg.org/psycopg3/docs/basic/copy.html#copy > >And if using psycopg2, execute_batch might be of value: > >https://www.psycopg.org/docs/extras.html?highlight=insert#psycopg2.extras.execute_batch > >Regards, > >Gavin > >
