pg10 benchmarksql性能测试结果

针对100warehouse进行不同并发的测试,测试程序和pg在一台机器上。

16线程5分钟

1
2
3
4
5
13:08:48,025 [Thread-10] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 152711.98
13:08:48,025 [Thread-10] INFO jTPCC : Term-00, Measured tpmTOTAL = 339066.1
13:08:48,026 [Thread-10] INFO jTPCC : Term-00, Session Start = 2017-10-15 13:03:48
13:08:48,026 [Thread-10] INFO jTPCC : Term-00, Session End = 2017-10-15 13:08:48
13:08:48,026 [Thread-10] INFO jTPCC : Term-00, Transaction Count = 1695403

32线程5分钟

1
2
3
4
5
13:18:47,976 [Thread-23] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 180131.78
13:18:47,976 [Thread-23] INFO jTPCC : Term-00, Measured tpmTOTAL = 400311.29
13:18:47,976 [Thread-23] INFO jTPCC : Term-00, Session Start = 2017-10-15 13:13:47
13:18:47,976 [Thread-23] INFO jTPCC : Term-00, Session End = 2017-10-15 13:18:47
13:18:47,976 [Thread-23] INFO jTPCC : Term-00, Transaction Count = 2001809

64线程5分钟

1
2
3
4
5
14:03:45,027 [Thread-37] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 206069.91
14:03:45,027 [Thread-37] INFO jTPCC : Term-00, Measured tpmTOTAL = 458176.41
14:03:45,027 [Thread-37] INFO jTPCC : Term-00, Session Start = 2017-10-15 13:58:44
14:03:45,027 [Thread-37] INFO jTPCC : Term-00, Session End = 2017-10-15 14:03:45
14:03:45,028 [Thread-37] INFO jTPCC : Term-00, Transaction Count = 2291240

128线程5分钟

1
2
3
4
5
14:09:37,989 [Thread-71] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 197745.74
14:09:37,989 [Thread-71] INFO jTPCC : Term-00, Measured tpmTOTAL = 439031.81
14:09:37,989 [Thread-71] INFO jTPCC : Term-00, Session Start = 2017-10-15 14:04:37
14:09:37,989 [Thread-71] INFO jTPCC : Term-00, Session End = 2017-10-15 14:09:37
14:09:37,990 [Thread-71] INFO jTPCC : Term-00, Transaction Count = 2196402

本文标题:pg10 benchmarksql性能测试结果

文章作者:Louis

发布时间:2017年10月16日 - 10:10

最后更新:2017年10月16日 - 17:10

原始链接:/2017/10/16/pg-benchmarksql/

许可协议: Louis-非商业性使用-禁止演绎 4.0 国际 转载请保留原文链接及作者。