https://www.percona.com/blog/tuning-postgresql-for-sysbench-tpcc/ Thu, 11 Apr 2024 22:17:39 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/tuning-postgresql-for-sysbench-tpcc/#comment-10972236 Mon, 18 May 2020 05:57:41 +0000 https://www.percona.com/blog/?p=50577#comment-10972236 Great post, thanks! The detailed steps and the tool are very helpful. One question though: We have been running this tool on PostgreSQL version 12 on a hardware configuration similar to the one in this post, following the steps and settings in this post. We observe that there is a high variance in the tps (order of magnitude difference between maximum and minimum tps) in the ‘run’ phase. Consequentially, its been hard to get a consistent result between multiple runs, even with a run time as long as an hour. Is that to be expected? Any suggestions/pointers are welcome.

]]> https://www.percona.com/blog/tuning-postgresql-for-sysbench-tpcc/#comment-10969299 Mon, 18 Jun 2018 17:26:40 +0000 https://www.percona.com/blog/?p=50577#comment-10969299 Thank You Mark. We would surely look into Linkbench.

]]> https://www.percona.com/blog/tuning-postgresql-for-sysbench-tpcc/#comment-10969298 Mon, 18 Jun 2018 17:22:11 +0000 https://www.percona.com/blog/?p=50577#comment-10969298 And while the insert benchmark doesn’t support Postgres, I assume the changes would be trivial.
https://github.com/mdcallag/mytools/tree/master/bench/ibench

]]> https://www.percona.com/blog/tuning-postgresql-for-sysbench-tpcc/#comment-10969297 Mon, 18 Jun 2018 17:21:05 +0000 https://www.percona.com/blog/?p=50577#comment-10969297 Excellent post. I hope you include Linkbench when you have time. There is support for it in https://github.com/mdcallag/linkbench

]]>