I've set up 2 VirtualBox machines with the same parameters.
The first one with Debian 10 - PostgreSQL 11, the second with Debian 11 - PostgreSQL 13.
The installation is only the base system + SSH server - no additional package.
The postgres configuration has been left as in the package default - no variation at all.
I've set up the same test db using pgbench with a scaling factor of 100 and then executed the following test several times on both machines:
$ pgbench -r -T 60 test
Test are sometimes in parallel, sometimes in sequence, randomly selecting the first server.
These are the results (transactions completed):
Debian10
1370
1569
1753
1208
1831
1126
1289
1159
1130
Average: 1381
Debian11
1143
1314
1626
1119
1733
1058
1175
1057
1089
Average: 1257
Debian 11 with PostgreSQL 13 seems always slower than the older version. Test have been repeated several times without registering results, but always with 13 slower than 11.
Notes:
- same results with longer tests
- configurations are the same on the 2 server to allow compare: I want to undestand if there are problems in standard Debian settings and how to deal with them
- the problem is linked to a programmed upgrade that can't be done with a server 10% slower
Did you find the same problem?
It depends on Debian compile time configurations?
