jail-pgbench

Intel Xeon E5-2630 v3 testing on FreeBSD via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2410290-SCHA-JAILPGB71&grr.

jail-pgbenchProcessorMotherboardMemoryDiskAudioOSKernelCompilerFile-SystemIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789Intel Xeon E5-2630 v3 @ 2.40GHz (32 Cores)Supermicro X10DRi 12345678964GB13242GBNVIDIA (0x0fb9) HDAFreeBSD13.4-RELEASE (x86_64)Clang 18.1.6zfsOpenBenchmarking.org- KPTI

jail-pgbenchpgbench: 1000 - 1000 - Read Write - Average Latencypgbench: 1000 - 1000 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 800 - Read Write - Average Latencypgbench: 1000 - 800 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1 - 1000 - Read Write - Average Latencypgbench: 1 - 1000 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1 - 800 - Read Write - Average Latencypgbench: 1 - 800 - Read Writepgbench: 1000 - 1000 - Read Only - Average Latencypgbench: 1000 - 1000 - Read Onlypgbench: 1000 - 800 - Read Only - Average Latencypgbench: 1000 - 800 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 100 - 800 - Read Only - Average Latencypgbench: 100 - 800 - Read Onlypgbench: 100 - 1000 - Read Only - Average Latencypgbench: 100 - 1000 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 1000 - Read Write - Average Latencypgbench: 100 - 1000 - Read Writepgbench: 100 - 800 - Read Write - Average Latencypgbench: 100 - 800 - Read Writepgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 1 - 1000 - Read Only - Average Latencypgbench: 1 - 1000 - Read Onlypgbench: 1 - 800 - Read Only - Average Latencypgbench: 1 - 800 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 1 - Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678989.6391121259.191423665.6081224163.30080081575.952638506.0609893.1281598831123.3447137.0861411355.5041453511.5561607172.1213772492.8983450641.19241942796.3781037672.248110770.56244469322.0861132242.412117932.3514253901.7594547541.041480296189.18813220.505494668OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678920406080100SE +/- 2.29, N = 989.641. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892K4K6K8K10KSE +/- 276.37, N = 9112121. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891326395265SE +/- 1.15, N = 959.191. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567899001800270036004500SE +/- 79.32, N = 942361. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891530456075SE +/- 1.52, N = 865.611. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 800 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567893K6K9K12K15KSE +/- 293.93, N = 8122411. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891428425670SE +/- 2.73, N = 863.301. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892K4K6K8K10KSE +/- 364.50, N = 880081. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930060090012001500SE +/- 32.91, N = 121575.951. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789140280420560700SE +/- 13.26, N = 126381. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789110220330440550SE +/- 4.63, N = 12506.061. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892004006008001000SE +/- 9.07, N = 129891. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.70381.40762.11142.81523.519SE +/- 0.031, N = 53.1281. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930K60K90K120K150KSE +/- 1620.16, N = 51598831. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892004006008001000SE +/- 14.79, N = 91123.341. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 800 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789150300450600750SE +/- 9.41, N = 97131. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789246810SE +/- 0.039, N = 37.0861. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 1000 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 1000 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930K60K90K120K150KSE +/- 781.62, N = 31411351. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891.23842.47683.71524.95366.192SE +/- 0.016, N = 35.5041. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 800 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 800 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930K60K90K120K150KSE +/- 412.87, N = 31453511. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.35010.70021.05031.40041.7505SE +/- 0.010, N = 31.5561. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1000 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930K60K90K120K150KSE +/- 1058.40, N = 31607171. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.47720.95441.43161.90882.386SE +/- 0.014, N = 32.1211. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 800 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678980K160K240K320K400KSE +/- 2534.42, N = 33772491. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.65211.30421.95632.60843.2605SE +/- 0.012, N = 32.8981. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678970K140K210K280K350KSE +/- 1402.86, N = 33450641. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.26820.53640.80461.07281.341SE +/- 0.008, N = 31.1921. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678990K180K270K360K450KSE +/- 2836.73, N = 34194271. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678920406080100SE +/- 0.48, N = 396.381. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 1000 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 1000 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892K4K6K8K10KSE +/- 51.92, N = 3103761. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891632486480SE +/- 0.98, N = 372.251. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 800 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 800 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892K4K6K8K10KSE +/- 147.98, N = 3110771. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.12650.2530.37950.5060.6325SE +/- 0.002, N = 30.5621. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789100K200K300K400K500KSE +/- 1539.30, N = 34446931. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789510152025SE +/- 0.25, N = 322.091. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 250 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567892K4K6K8K10KSE +/- 125.45, N = 3113221. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567891020304050SE +/- 0.56, N = 342.411. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 100 - Clients: 500 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 100 - Clients: 500 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567893K6K9K12K15KSE +/- 156.97, N = 3117931. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.5291.0581.5872.1162.645SE +/- 0.013, N = 32.3511. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 1000 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 1000 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678990K180K270K360K450KSE +/- 2332.27, N = 34253901. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.39580.79161.18741.58321.979SE +/- 0.001, N = 31.7591. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 800 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 800 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789100K200K300K400K500KSE +/- 122.86, N = 34547541. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.23420.46840.70260.93681.171SE +/- 0.002, N = 31.0411. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 500 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789100K200K300K400K500KSE +/- 1033.61, N = 34802961. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567894080120160200SE +/- 2.73, N = 3189.191. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read WriteIntel Xeon E5-2630 v3 - - Supermicro X10DRi 12345678930060090012001500SE +/- 18.82, N = 313221. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average Latency

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 1234567890.11360.22720.34080.45440.568SE +/- 0.001, N = 30.5051. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

PostgreSQL

Scaling Factor: 1 - Clients: 250 - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 17Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyIntel Xeon E5-2630 v3 - - Supermicro X10DRi 123456789110K220K330K440K550KSE +/- 961.24, N = 34946681. (CC) clang options: -fno-strict-aliasing -fwrapv -O2 -lpq -lpgcommon -lpgport -lpthread -lexecinfo -lm

Phoronix Test Suite v10.8.5