Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Ok, thanks
-- Sent from Mail.ru app for Android
The notion of COPY blocks and asynchronously is very interesting
From: Gavin Roy <gavinr@aweber.com> Sent: Wednesday, November 24, 2021 1:50 PMTo: Godfrin, Philippe E <Philippe.Godfrin@nov.com>Cc: pgsql-general@lists.postgresql.orgSubject: [EXTERNAL] Re: Inserts and bad performance
On Wed, Nov 24, 2021 at 2:15 PM Godfrin, Philippe E <Philippe.Godfrin@nov.com> wrote:
GreetingsI am inserting a large number of rows, 5,10, 15 million. The python code commits every 5000 inserts. The table has partitioned children.
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
В списке pgsql-general по дате отправления: