Tomas Vondra wrote: > Yes, I'd like to repeat the tests with other workloads - I'm thinking about > regular pgbench and perhaps something that'd qualify as 'mostly read-only' > (not having a clear idea how that should work).
You can use "-bselect-only@9 -bsimple-update@1" for a workload that's 10% the write transactions and 90% the read-only transactions. If you have custom .sql scripts you can use the @ with -f too. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers