PGBench results for latest changes.

[Jan-M]

PG Bench

5.5.15 kernel, pg12, amd 3700x

scaling factor: 100
query mode: simple
number of clients: 8
number of threads: 1
duration: 30 s

No Extension

postgres@jan-desktop:~$ pgbench -v -c 8 -T 30 -P 5 -b select-only

tps = 165957.354336 (including connections establishing)
tps = 165966.579402 (excluding connections establishing)

tps = 162879.259330 (including connections establishing)
tps = 162888.133695 (excluding connections establishing)

tps = 164322.227226 (including connections establishing)
tps = 164331.266112 (excluding connections establishing)

With old extension

postgres@jan-desktop:~$ pgbench -v -c 8 -T 30 -P 5 -b select-only
tps = 158320.373133 (including connections establishing)
tps = 158329.517331 (excluding connections establishing)

tps = 160237.955651 (including connections establishing)
tps = 160246.182183 (excluding connections establishing)

tps = 161192.523582 (including connections establishing)
tps = 161201.108915 (excluding connections establishing)

tps = 158030.672708 (including connections establishing)
tps = 158039.067090 (excluding connections establishing)

New extension

postgres@jan-desktop:~$ pgbench -v -c 8 -T 30 -P 5 -b select-only
tps = 158565.856476 (including connections establishing)
tps = 158575.178664 (excluding connections establishing)

tps = 160018.482747 (including connections establishing)
tps = 160027.233723 (excluding connections establishing)

tps = 159913.453535 (including connections establishing)
tps = 159921.790121 (excluding connections establishing)

tps = 160001.599605 (including connections establishing)
tps = 160010.372040 (excluding connections establishing)

On average new extension costs 0.89 percent performance from this small sample set and read only test..

[Jan-M]

No extension

tps = 158984.602253 (including connections establishing)
tps = 158989.577137 (excluding connections establishing)

tps = 158793.748528 (including connections establishing)
tps = 158799.233784 (excluding connections establishing)

tps = 159734.117210 (including connections establishing)
tps = 159739.313994 (excluding connections establishing)

New version, oids, locks, ...

tps = 157739.586315 (including connections establishing)
tps = 157745.536086 (excluding connections establishing)

tps = 156236.443705 (including connections establishing)
tps = 156242.137195 (excluding connections establishing)

tps = 155120.789246 (including connections establishing)
tps = 155126.624940 (excluding connections establishing)