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
- number of client: 1
- number of thread: 1
- number of transactions per client: 3000
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 |