There is an interesting tool called nancy that runs automated experiments with different postgres setups, allowing you to compare them against each other. It c

There is an interesting tool called nancy that runs automated experiments with different postgres setups, allowing you to compare them against each other. It can run workloads derived from log files or pgbench (disclaimer, I wrote the pgbench support). The idea is, you run many experiments, tweaking different configurations and nancy automates the analysis of them, eventually allowing you to settle into a cost minimum/performance maximum you're comfortable with. https://github.com/postgres-ai/nancy https://github.com/postgres-ai/nancy