Re: PSQL performance - TPS

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