Update and review the JMeter test plans to PG13 benchmarking
Update the outdated JMeter test plans
Tasks:
-
Update JMeter to latest version (5.5) -
Collect top 80% statements at peak period (between 14:00 and 16:00 UTC) from pg_stat_statements
consideringtotal_exec_time
-
Gather variables for the workload: - Based on table's statistics (
pg_statistic
) - Based on logged queries (postgresql logs), if possible?
- Based on table's statistics (
-
Update by-time
JMeter plans atdb-migration/benchmark
:-
plans
:- by-time-ci-related.jmx
- by-time-ci-unrelated.jmx
-
plans-secondaries
:- by-time-ci-related-secondaries.jmx
- by-time-ci-unrelated-secondaries.jmx
-
Edited by Rafael Henchen