Configuring the database server for pgbench

All the queries used for the built-in tests are simple: they are at most using a primary key index to look a row up, but no joins or more complicated query types. However, the statements executed will stress both the writes and the buffer cache's ability to keep up.

Accordingly, parameters you might adjust break down into three major categories: