Re: PSQL performance - TPS

> Application as a whole is expected to give an throughput of 100k
transactions per sec.
> On this env(8core cpu, 16GB) what is the TPS that we can expect?

as a reference - maybe you can reuse/adapt the "TechEmpower Framework
Benchmarks" tests - and compare your PG9.6+hardware results.

The new TechEmpower Framework Benchmarks [2019-07-09 Round 18]
* reference numbers:
https://www.techempower.com/benchmarks/#section=data-r18&hw=ph&test=update
* source code: https://github.com/TechEmpower/FrameworkBenchmarks
* PG11 config:
https://github.com/TechEmpower/FrameworkBenchmarks/blob/master/toolset/databases/postgres/postgresql.conf
* java frameworks:
https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/frameworks/Java

> We have tested with a simple Java code firing insert

As I see - There are lot of java framework - and sometimes 10x difference
in performance :
https://www.techempower.com/benchmarks/#section=data-r18&hw=ph&test=update

"Responses per second at 20 updates per request, Dell R440 Xeon Gold + 10
GbE"
( "Intel Xeon Gold 5120 CPU (14c28t) , 32 GB of memory, and an enterprise
SSD. Dedicated Cisco 10-gigabit Ethernet switch")
* java + PG11 results: low:126 -> high:21807

"Responses per second at 20 updates per request, Azure D3v2 instances"
* java + PG11 results: low:329 -> high:2975

best,
Imre

Shital A <brightuser2019(at)gmail(dot)com> ezt írta (időpont: 2019. aug. 1., Cs,
5:11):

> Hello,
>
> We are working on development of an application with postgresql 9.6 as
> backend. Application as a whole is expected to give an throughput of 100k
> transactions per sec. The transactions are received by DB from component
> firing DMLs in ad-hoc fashion i.e. the commits are fired after random
> numbers of transaction like 2,3,4. There is no bulk loading of records. DB
> should have HA setup in active passive streaming replication. We are doing
> a test setup on a 8-core machine having 16 GB RAM. Actual HW will be
> better.
>
> 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?
>
>
> Thanks.
>