性能参考

PostgreSQL 性能参考（ pgbench, sysbench, TPC-H）

https://github.com/Vonng/pgtpc

TPC benchmark for PostgreSQL

Apple M1 Max

SPEC: CPU = 10C, Memory = 64G, SSD = 8TB

pgbench

s = 1000, RW = 32K TPS , RO = 241K QPS

TPS / Latency (µs)c=1c=2c=4c=8c=16c=32
s=1000, RO, TPS71748107309174629200917228209240841
s=1000, RO, LAT141822365696
s=1000, RW, TPS92541320121549298823013031903
s=1000, RW, LAT108151184264516953

sysbench

s = 160M , PointSelect = 170K QPS , PointUpdate = 68K QPS, RW Xact = 3912 tps

mode \ thread1248
oltp_point_select41215 / 20µs80037 / 20µs150319 / 30µs170095 / 50µs
oltp_update_non_index15583 / 60µs31642 / 60µs51131 / 80µs67958 / 120µs
oltp_update_index12703 / 80µs23376 / 90µs37165 / 110µs48490 / 160µs
oltp_read_write885 / 1130µs1370 / 1460µs2694/ 1480µs3912/ 2040ms

Conpare with TiDB 6.0 on 72C / 234G , PointSelect = 424K QPS , PointUpdate = 59K QPS, RWXact = 6029 tps

mode300600900
oltp_point_select265208365174424031
oltp_update_non_index408145174659095
oltp_update_index181872227025118
oltp_read_write482956936029

TPCH

FactorTime (s)Spec
1810C / 64G
105610C / 64G
50132710C / 64G
100483510C / 64G

Compare with other databases:

DatabaseTPCH FactorTotal Time (s)Hardware SpecSource
PostgreSQL1810C / 64GVonng
PostgreSQL105610C / 64GVonng
PostgreSQL50132710C / 64GVonng
PostgreSQL100483510C / 64GVonng
TiDB100190120C / 570GTiDB
Greenplum100436120C / 570GTiDB
Spark100388120C / 570GTiDB
OceanBase10018996C / 384GOceanBase
PolarDB5038732C / 128G阿里云
PolarDB5075516C / 64G阿里云
StoneDB100338864C / 128GStoneDB
ClickHouse1001153764C / 128GStoneDB

最后修改 2023-02-27: update zh docs (a5a4cc0)