Repository files navigation

The following data sets contain the raw performance data and metadata of the associated blog postTODO on comparing the performance of PostgreSQL for the version 15.4 and 16.0.

The performance measurements comprise four workloads:

1. read-heavy, non-transactional by theYahoo Cloud Serving Benchmark (YCSB)
2. read-update, non-transactional by theYahoo Cloud Serving Benchmark (YCSB)
3. TPC-C, transactional byBenchBase TPC-C
4. TPC-H, transactional byBenchBase TPC-H

Each folder contains the data of a single run benchmark of one configuration. Each configuration is measured three times.

In order to ensure full transparency and reproducibility, each data folder contains benchmark configuration data, performance data, monitoring data, cloud provider metadata, VM metadata and DBMS configuration data.

In addition theaggregation.xlsx provides an abstracted view over all data points.

All configurable benchmark parameters are defined in theevaluationScenario.json.

ThebenchANT_versions contains the used versions of the benchANT software components to execute the benchmarks.

The execution logs of the individual benchmark steps are contained inairflowTaskInstanceDetails.json.

The raw performance data output of the YCSB/BenchBase is contained in the0_load.txt for the LOAD phase and in the0_run.txtfor the RUN phase. The database ranking data only considers the RUN phase.

In addition, theruntimeDataframe.xlsx represents a cleaned time-series of the LOAD and RUN phase performance data.

Thevalidate.json provides a validation overview of the raw benchmark results.

The DBMS cluster and the benchmark instances are monitored withTelegraf and the data is stored inInfluxDB.

A full snapshot of the monitoring data of each run is contained in theinflux_data.zip file.

The time frame of the RUN phase for the relevant metrics is extracted in thedbmsMetrics.xlsx.

The cloud provider metadata for the DBMS deployment is contained in thedbms_data_resources.json /dbms_management_resources.json and for the benchmark deployment in thebenchmark_resources.json.

The VM metadata for the DBMS deployment is contained in thedbms_data_hardware_facts.json /dbms_management_hardware_facts.json and for the benchmark deployment in thebenchmark_hardware_facts.json.

For each DBMS, relevant configuration files and cluster states are stored before executing the workload.

DBMS-specific files are contained in each folder, e.g.postgresql.conf for PostgreSQL DBMS deployments.

In case of questions or feedback on the data feel free to reach out toinfo@benchant.com