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 <andres@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.