Re: SV: Insertion time is very high for inserting data in postgres

2021-02-11 Thread Peter J. Holzer
On 2021-02-10 11:10:41 +, Niels Jespersen wrote: > >Fra: prachi surangalikar > >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

Re: Insertion time is very high for inserting data in postgres

2021-02-10 Thread Dave Cramer
On Wed, 10 Feb 2021 at 06:11, Niels Jespersen wrote: > >Fra: prachi surangalikar > > > > > >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 insertio

SV: Insertion time is very high for inserting data in postgres

2021-02-10 Thread Niels Jespersen
>Fra: prachi surangalikar > >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

Re: Insertion time is very high for inserting data in postgres

2021-02-10 Thread Ganesh Korde
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 in

Insertion time is very high for inserting data in postgres

2021-02-10 Thread prachi surangalikar
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 fet