CODEWITHSUNDEEP
linuxpostgresqlubuntuintelpgbench
user3926246
user3926246

Reputation: 47

Postgres low performance on 13th gen i9

I use pgbench for Postgres 12 (default config) and the results are as follows:

pgbench -i -U postgres -s 50 db_test

pgbench -c 1 -j 1 -t 3000 -U postgres db_test

Result

Device CPU OS Memory Kernel latency average
#1 Core i5 gen 12th Ubuntu 20.x 16GB 5.x 0.450 ms
#2 Core i7 gen 10th Ubuntu 20.x 16GB 5.x 0.625 ms
#3 Core i9 gen 13th ( P-core and E-core enable All) Ubuntu 20.x 64GB 5.x 10.213 ms
#4 Core i9 gen 12th ( P-core and E-core enable All) Ubuntu 20.x 64GB 6.7.2 12.161ms

I have researched but don't have an answer. Please help me

Device CPU OS Memory Kernel Postgresql latency average
#3 Core i9 gen 13th ( P-core and E-core enable All) Ubuntu 22.04.3 64GB 6.5.0-15-generic 16.1 4.836 ms
#3 Core i9 gen 13th ( P-core and E-core enable All) Ubuntu 22.04.3 64GB 6.5.0-15-generic 11.22 5.257 ms

Upvotes: 1

Views: 101

Answers (0)

Related Questions