On Wed, 10 Feb 2021, 1:56 pm prachi surangalikar, < surangalikarprachi...@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.
