Hi,
I follow up myself: I was using pgbench with the wrong scale size.
With the configuration I posted before and scale=100 I Get the
following:
sudo -u postgres pgbench -c 10 -t 10000 -s 100
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 4399.753895 (including connections establishing)
tps = 4405.228901 (excluding connections establishing)
sudo -u postgres pgbench -c 50 -t 10000 -s 100
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 50
number of transactions per client: 10000
number of transactions actually processed: 500000/500000
tps = 3208.532479 (including connections establishing)
tps = 3211.816174 (excluding connections establishing)
which I think is in line with the expectations.
Thanks,
e.
