What's the difference between the tpcc of PostgreSQL 12 and PostgreSQL 11?
This article mainly explains "what is the difference between the tpcc of PostgreSQL 12 and PostgreSQL 11". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the difference between the tpcc of PostgreSQL 12 and PostgreSQL 11"?
PG 12
test data
. / runSQL.sh props.pg sqlTableDrops./runSQL.sh props.pg sqlTableCreates./runLoader.sh props.pg numwarehouses 32./runSQL.sh props.pg sqlIndexCreates
Running result
[pg12@localhost run] $. / runBenchmark.sh props.pg2019-11-11 15 INFO-Term-00, 2019-11-11 15 INFO-Term-00, +-+ 2019-11-11 15 INFO-Term-00 BenchmarkSQL v4.1.12019-11-11 15 INFO-Term-00, +-+ 2019-11-11 15 INFO-Term-00, (c) 2003, Raul Barbosa2019-11-11 15 INFO-Term-00 (C) 2004-2016, Denis Lussier2019-11-11 15 Term-00 10 Term-00 24697 INFO-Term-00, (c) 2016, Jan Wieck2019-11-11 15 15 INFO-Term-00, +-+ 2019-11-11 15 INFO-Term-00 2019-11-11 15 driver=org.postgresql.Driver2019 10 driver=org.postgresql.Driver2019 24697 INFO-Term-00, conn=jdbc:postgresql://192.168.26.28:5432/benchmarkdb2019-11-11 15 14 INFO-Term-00, user=pg122019-11-11 15 10 INFO-Term-00, 2019-11-11 15 INFO-Term-00, warehouses=322019-11-11 15 15 INFO-Term-00, terminals=202019-11-11 15 15 10 INFO-Term-00, terminals=202019-11 15 10 INFO-Term-00 RunMins=102019-11-11 15 limitTxnsPerMin=02019 10 Term-00 24698 INFO-Term-00, 2019-11-11 15 15 limitTxnsPerMin=02019 10 limitTxnsPerMin=02019 24698 INFO-Term-00, newOrderWeight=45 Term-00, Running Average t2019-11-11 15 15 20 limitTxnsPerMin=02019-INFO-Term-00, 64444 Memory Usage: 40MB / 55MB 2019-11-11 1520 20 INFO-Term-00 2019-11-11 15 NewOrders 20 Measured tpmC 25060 INFO-Term-00, Measured tpmC (NewOrders) = 7903.72 2019-11-11 15 Measured tpmC 20V 25060 INFO-Term-00 Measured tpmTOTAL = 17589.51 2019-11-11 15 Term-00 20 Term-00 20 INFO-Term-00, Session Start = 2019-11-11 15:10:24 2019-11-11 15 15 practice 20 INFO-Term-00 Session End = 2019-11-11 15:20:25 2019-11-11 15-15-15-15-15-15-15-15-15-15-15-15-15-15-15-15-15-15-15-11-11-11-11-11-11 15:20:25 2019-11-11 15-15-15-15-15-15-15-15-15-15-15-15-15-15-11-11-11-11 15:20:25 2019-11-11 15:20:25-11-11-11-11 15:20:25-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11-11 2019-11-11
PG 11
test data
. / runSQL.sh props.pg sqlTableDrops./runSQL.sh props.pg sqlTableCreates./runLoader.sh props.pg numwarehouses 32./runSQL.sh props.pg sqlIndexCreates
Running result
[xdb@localhost run] $. / runBenchmark.sh props.pg2019-11-11 15 INFO-Term-00, 2019-11-11 15 Term-00 29 INFO-Term-00, +-+ 2019-11-11 15 INFO-Term-00 BenchmarkSQL v4.1.12019-11-11 15 INFO-Term-00, +-+ 2019-11-11 15 INFO-Term-00, (c) 2003, Raul Barbosa2019-11-11 15 INFO-Term-00 (C) 2004-2016, Denis Lussier2019-11-11 15 Jan Wieck2019 2914 INFO-Term-00, (c) 2016, Jan Wieck2019-11-11 15 Jan Wieck2019-11 15 INFO-Term-00, +-+ 2019-11-11 15 Swiss 2926946 INFO-Term-00 2019-11-11 15 driver=org.postgresql.Driver2019 29 INFO-Term-00, conn=jdbc:postgresql://192.168.26.28:5433/benchmarkdb2019-11-11 15 INFO-29 INFO-Term-00, user=xdb2019-11-11 15 INFO-29 26946 INFO-Term-00, 2019-11-11 15 INFO-Term-00, warehouses=322019-11-11 15 INFO-29 INFO-Term-00, terminals=202019-11-11 15 INFO 2929946 INFO-Term-00 RunMins=102019-11-11 15 limitTxnsPerMin=02019 29 Term-00 26946 INFO-Term-00, 2019-11-11 15 limitTxnsPerMin=02019 29 26946 INFO-Term-00, newOrderWeight=45 Term-00, Running Average t2019-11-11 15 39 Term-00 27285 INFO-Term-00, 75628 Memory Usage: 43MB / 58MB 2019-11-11 15 39 INFO-Term-00 2019-11-11 15 Measured tpmC 39 Measured tpmC 27286 INFO-Term-00, Measured tpmC (NewOrders) = 8014.34 2019-11-11 15 39 Measured tpmC 27286 INFO-Term-00 Measured tpmTOTAL = 17795.79 2019-11-11 15 Term-00 39 Term-00 INFO-Term-00, Session Start = 2019-11-11 15:29:27 2019-11-11 15 Switzerland 3914 INFO-Term-00 Session End = 2019-11-11 15:39:27 2019-11-11 15 purl 39pur27286 INFO-Term-00, Transaction Count = 178018 [xdb@localhost run] $
PG 12 7903 vs PG 11 8014, the difference is not significant.
Thank you for your reading. The above is the content of "what is the difference between the tpcc of PostgreSQL 12 and PostgreSQL 11". After the study of this article, I believe you have a deeper understanding of the difference between the tpcc of PostgreSQL 12 and PostgreSQL 11, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
