Postgres Pro
Downloads
Home   >   mailing lists

Re: Insertion time is very high for inserting data in postgres - Mailing list pgsql-general

From Ganesh Korde
Subject Re: Insertion time is very high for inserting data in postgres
Date
Msg-id CAPNyb0V-xm+wcMLtkf1p4pe6+D=OUuj9=vyPWOC1Sj9aEpXckQ@mail.gmail.com
Whole thread Raw
In response to Insertion time is very high for inserting data in postgres  (prachi surangalikar <surangalikarprachi100@gmail.com>)
List pgsql-general
Tree view


On Wed, 10 Feb 2021, 1:56 pm prachi surangalikar, <surangalikarprachi100@gmail.com> wrote:
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.
Are you doing vaccuum analyze table regularly?  If not then that might delay insertion.

pgsql-general by date:

Previous
From: Rajnish Vishwakarma
Date:
Subject: Regarding Postgres - Insertion Time Getting Increased As Data Volume is getting increased
Next
From: Thorsten Schöning
Date:
Subject: Re: Increased size of database dump even though LESS consumed storage