>Fra: prachi surangalikar <surangalikarprachi100@gmail.com> > >Hello Team,>Greetings!> >We are using Postgres 12.2.1 for fetching per minute data for about 25 machines but running parallely via a single thread in python.>But suddenly the insertion time has increased to a very high level, about 30 second for one machine.>We are in so much problem as the data fetching is becoming slow.
>Fra: prachi surangalikar <surangalikarprachi100@gmail.com>
>
>Hello Team,
>Greetings!
>We are using Postgres 12.2.1 for fetching per minute data for about 25 machines but running parallely via a single thread in python.
>But suddenly the insertion time has increased to a very high level, about 30 second for one machine.
>We are in so much problem as the data fetching is becoming slow.
> >if anyone could help us to solve this problem it would be of great help to us. Get your data into a Text.IO memory structure and then use copy https://www.psycopg.org/docs/usage.html#using-copy-to-and-copy-from This is THE way of high-performant inserts using Postgres. Regards Niels Jespersen
>if anyone could help us to solve this problem it would be of great help to us.
Get your data into a Text.IO memory structure and then use copy https://www.psycopg.org/docs/usage.html#using-copy-to-and-copy-from
This is THE way of high-performant inserts using Postgres.
Regards Niels Jespersen
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
