Hello,
If all the data is in memory and you have a system with fast fsyncs (or are running with fsync off, or unlogged tables, or synchronous_commit off), then the big bottleneck in pgbench is the amount of back and forth between the pgbench program and the backend.
Sure. The throughput of a benchmark depends on a bottleneck which may be disk ios, cpu, network, load... depending on the test conditions.
I tested quite a few variants for my PgDay Paris 2017 talk, including PL functions, see https://wiki.postgresql.org/wiki/PgDay_Paris_2017.
-- Fabien. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
