Add benchmarking and accompanying documentation

[staaldraad]

What is currently missing?

Benchmarking

How could this be improved?

Should create proper benchmarking but just quick run with pgbench defaults shows no impact;

OFF

[postgres@fedora ~]$ pgbench -c 10 -j 2 -t 10000
pgbench (14.1)
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 50
query mode: simple
number of clients: 10
number of threads: 2
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 10.176 ms
initial connection time = 7.813 ms
tps = 982.682385 (without initial connection time)

ON

[postgres@fedora ~]$ pgbench -c 10 -j 2 -t 10000
pgbench (14.1)
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 50
query mode: simple
number of clients: 10
number of threads: 2
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 9.176 ms
initial connection time = 7.435 ms
tps = 1089.844147 (without initial connection time)

Is this a feature you would work on yourself?

• I plan to open a pull request for this feature