Insertion time is very high for inserting data in postgres

Поиск
Список
Период
Сортировка
От prachi surangalikar
Тема Insertion time is very high for inserting data in postgres
Дата
Msg-id CAFeB3PVKPcS77-cwJ-oy9=0=jKdsQ2rCzQnXsKxhKnbqQDHMJg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Insertion time is very high for inserting data in postgres  (Ganesh Korde <ganeshakorde@gmail.com>)
SV: Insertion time is very high for inserting data in postgres  (Niels Jespersen <NJN@dst.dk>)
Список pgsql-general
Дерево обсуждения
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Bryn Llewellyn
Дата:
Сообщение: Re: psql behavior change on upgrade from version 12.x to 13.1
Следующее
От: Rajnish Vishwakarma
Дата:
Сообщение: Regarding Postgres - Insertion Time Getting Increased As Data Volume is getting increased