Re: PSQL performance - TPS

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(at)anarazel(dot)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
>
>
>