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, <gavinflo...@archidevsys.co.nz> wrote: > On 01/08/2019 15:10, Shital A wrote: > > 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 numbers of transaction like 2,3,4. There is no bulk > > loading of records. DB should have HA setup in active passive > > streaming replication. We are doing a test setup on a 8-core machine > > having 16 GB RAM. Actual HW will be better. > > > > Need help in: > > 1. On this env(8core cpu, 16GB) what is the TPS that we can expect? We > > have tested with a simple Java code firing insert and commit in a loop > > on a simple table with one column. We get 1200 rows per sec. If we > > increase threads RPS decrease. > > > > 2. We have tuned some DB params like shared_buffers, sync_commit off, > > are there any other pointers to tune DB params? > > > > > > Thanks. > > Curious, why not use a more up-to-date version of Postgres, such 11.4? > As more recent versions tend to run faster and to be better optimised! > > You also need to specify the operating system! Hopefully you are > running a Linux or Unix O/S! > > > Cheers, > Gavin > > >
