Re: PSQL performance - TPS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux