这篇文章主要讲解了“PostgreSQL 12和PostgreSQL 11的tpcc有什么不同”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“PostgreSQL 12和PostgreSQL 11的tpcc有什么不同”吧！

PG 12
测试数据

./runSQL.shprops.pgsqlTableDrops./runSQL.shprops.pgsqlTableCreates./runLoader.shprops.pgnumwarehouses32./runSQL.shprops.pgsqlIndexCreates

运行结果

[pg12@localhostrun]$./runBenchmark.shprops.pg2019-11-1115:10:24,697INFO-Term-00,2019-11-1115:10:24,697INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:10:24,697INFO-Term-00,BenchmarkSQLv4.1.12019-11-1115:10:24,697INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:10:24,697INFO-Term-00,(c)2003,RaulBarbosa2019-11-1115:10:24,697INFO-Term-00,(c)2004-2016,DenisLussier2019-11-1115:10:24,697INFO-Term-00,(c)2016,JanWieck2019-11-1115:10:24,697INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:10:24,697INFO-Term-00,2019-11-1115:10:24,697INFO-Term-00,driver=org.postgresql.Driver2019-11-1115:10:24,697INFO-Term-00,conn=jdbc:postgresql://192.168.26.28:5432/benchmarkdb2019-11-1115:10:24,697INFO-Term-00,user=pg122019-11-1115:10:24,697INFO-Term-00,2019-11-1115:10:24,697INFO-Term-00,warehouses=322019-11-1115:10:24,697INFO-Term-00,terminals=202019-11-1115:10:24,697INFO-Term-00,runMins=102019-11-1115:10:24,698INFO-Term-00,limitTxnsPerMin=02019-11-1115:10:24,698INFO-Term-00,2019-11-1115:10:24,698INFO-Term-00,newOrderWeight=45Term-00,RunningAveraget2019-11-1115:20:25,060INFO-Term-00,64444MemoryUsage:40MB/55MB2019-11-1115:20:25,060INFO-Term-00,2019-11-1115:20:25,060INFO-Term-00,MeasuredtpmC(NewOrders)=7903.722019-11-1115:20:25,060INFO-Term-00,MeasuredtpmTOTAL=17589.512019-11-1115:20:25,060INFO-Term-00,SessionStart=2019-11-1115:10:242019-11-1115:20:25,060INFO-Term-00,SessionEnd=2019-11-1115:20:252019-11-1115:20:25,060INFO-Term-00,TransactionCount=175956[pg12@localhostrun]$

PG 11
测试数据

./runSQL.shprops.pgsqlTableDrops./runSQL.shprops.pgsqlTableCreates./runLoader.shprops.pgnumwarehouses32./runSQL.shprops.pgsqlIndexCreates

运行结果

[xdb@localhostrun]$./runBenchmark.shprops.pg2019-11-1115:29:26,945INFO-Term-00,2019-11-1115:29:26,946INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:29:26,946INFO-Term-00,BenchmarkSQLv4.1.12019-11-1115:29:26,946INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:29:26,946INFO-Term-00,(c)2003,RaulBarbosa2019-11-1115:29:26,946INFO-Term-00,(c)2004-2016,DenisLussier2019-11-1115:29:26,946INFO-Term-00,(c)2016,JanWieck2019-11-1115:29:26,946INFO-Term-00,+-------------------------------------------------------------+2019-11-1115:29:26,946INFO-Term-00,2019-11-1115:29:26,946INFO-Term-00,driver=org.postgresql.Driver2019-11-1115:29:26,946INFO-Term-00,conn=jdbc:postgresql://192.168.26.28:5433/benchmarkdb2019-11-1115:29:26,946INFO-Term-00,user=xdb2019-11-1115:29:26,946INFO-Term-00,2019-11-1115:29:26,946INFO-Term-00,warehouses=322019-11-1115:29:26,946INFO-Term-00,terminals=202019-11-1115:29:26,946INFO-Term-00,runMins=102019-11-1115:29:26,946INFO-Term-00,limitTxnsPerMin=02019-11-1115:29:26,946INFO-Term-00,2019-11-1115:29:26,946INFO-Term-00,newOrderWeight=45Term-00,RunningAveraget2019-11-1115:39:27,285INFO-Term-00,75628MemoryUsage:43MB/58MB2019-11-1115:39:27,285INFO-Term-00,2019-11-1115:39:27,286INFO-Term-00,MeasuredtpmC(NewOrders)=8014.342019-11-1115:39:27,286INFO-Term-00,MeasuredtpmTOTAL=17795.792019-11-1115:39:27,286INFO-Term-00,SessionStart=2019-11-1115:29:272019-11-1115:39:27,286INFO-Term-00,SessionEnd=2019-11-1115:39:272019-11-1115:39:27,286INFO-Term-00,TransactionCount=178018[xdb@localhostrun]$

PG 12 7903 vs PG 11 8014，差别不大。

感谢各位的阅读，以上就是“PostgreSQL 12和PostgreSQL 11的tpcc有什么不同”的内容了，经过本文的学习后，相信大家对PostgreSQL 12和PostgreSQL 11的tpcc有什么不同这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！