pageserver.toml copied from production, going against real S3
(SKs and compute is running on same box in neon_local)
Baseline: l0_flush section commented out.
./pg_install/v15/bin/pgbench -i -s 300 -I dtG 'postgresql://[email protected]:55432/postgres'
⇒ this produces 4.5 GiB of WAL and a database of 3.7GiB logical size
# baseline
admin@neon-loadtest:[~/neon]: ./pg_install/v15/bin/pgbench -i -s 300 -I dtG 'postgresql://[email protected]:55432/postgres'
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (server-side)...
done in 71.88 s (drop tables 0.00 s, create tables 0.01 s, server-side generate 71.87 s).
# fixed
admin@neon-loadtest:[~/neon]: ./pg_install/v15/bin/pgbench -i -s 300 -I dtG 'postgresql://[email protected]:55432/postgres'
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data (server-side)...
done in 70.97 s (drop tables 0.00 s, create tables 0.01 s, server-side generate 70.97 s).
Grafana: