I am not very surprised with these results. However, what’s the disk type? That can matter quite a bit.
On Thu, 1 Aug 2019 at 10:51 PM, Andres Freund <and...@anarazel.de> wrote: > Hi, > > On 2019-08-01 08:40:53 +0530, Shital A wrote: > > 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? > > If you've set synchronous_commit = off, and you still get only 1200 > transactions/sec, something else is off. Are you sure you set that? > > Are your clients in the same datacenter as your database? Otherwise it > could be that you're mostly seeing latency effects. > > Greetings, > > Andres Freund > > >