Re: PSQL performance - TPS

2019-08-01 Thread Shital A
On Thu, 1 Aug 2019, 23:58 Rick Otten, wrote: > > > On Thu, Aug 1, 2019 at 2:15 PM Andres Freund wrote: > >> Hi, >> >> On 2019-08-01 23:36:33 +0530, Purav Chovatia wrote: >> > > If you've set synchronous_commit = off, and you still get only 1200 >> > > transactions/sec, something else is off. Are

Re: PSQL performance - TPS

2019-07-31 Thread Shital A
Hello, Version 9.6 is used because the components interacting with DB support this version. OS is RHEL 7.6. Thanks! On Thu, 1 Aug 2019, 10:45 Gavin Flower, wrote: > On 01/08/2019 15:10, Shital A wrote: > > Hello, > > > > We are working on development of an application w

PSQL performance - TPS

2019-07-31 Thread Shital A
Hello, We are working on development of an application with postgresql 9.6 as backend. Application as a whole is expected to give an throughput of 100k transactions per sec. The transactions are received by DB from component firing DMLs in ad-hoc fashion i.e. the commits are fired after random num