Date: Thu, 1 Aug 2019 10:21:28 -0700
From: Andres Freund <andres@anarazel.de>
To: Shital A <brightuser2019@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: PSQL performance - TPS
Message-ID: <20190801172128.ct3absxmogavdv6v@alap3.anarazel.de>
References: 
 <CAMp7vw8hHwVs-99Pph4GwmVENYaa5HGVVaa8_ED=FPbdf42ovQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAMp7vw8hHwVs-99Pph4GwmVENYaa5HGVVaa8_ED=FPbdf42ovQ@mail.gmail.com>
Precedence: bulk

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