Insertion time is very high for inserting data in postgres

From: prachi surangalikar <surangalikarprachi100(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Insertion time is very high for inserting data in postgres
Date: 2021-02-10 04:54:08
Message-ID: CAFeB3PVKPcS77-cwJ-oy9=0=jKdsQ2rCzQnXsKxhKnbqQDHMJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajnish Vishwakarma 2021-02-10 08:14:13 Regarding Postgres - Insertion Time Getting Increased As Data Volume is getting increased
Previous Message Bryn Llewellyn 2021-02-10 02:29:59 Re: psql behavior change on upgrade from version 12.x to 13.1