Skip to content

Execute database benchmarking on Postgresql 11

The goal is to check our load on PostgreSQL 11 and verify that the performance is similar or better. We could find some queries that the performance could change with the new planner, so we would like to reduce these cases.

We would execute the benchmark with the same concept that we have planned to test our primary database.

The main steps will be:

  • List the queries from pg_stat_statements

  • Execute a JMeter from a different host to reproduce the queries against the database, to generate similar traffic as production.

Edited by Alberto Ramos