ChangeLog

v2.0.10 (2024-09-09)

- Update man page make rules to match docutils v0.21.1 set since v2.0.7
- Fix run script logic to calculate metrics only when both power and throughput
  tests are run, not when only one of them is run
- mysql: remove logic for self-setting the set number in refresh stream 2, this
  is currently handled in the throughput-stream script
- mysql: update loading to handle chunking of data files
- mysql: change default behavior of scripts to work against an existing instance
  without having operating system privileges to start and stop the database
- mysql: update scripts to handle --socket flag

v2.0.9 (2024-08-20)

- Do not calculate composite score unless all tests are run since the score is
  based on the results of each test
- run: now able to control existing chunking option in load test with
  --parallelism flag, otherwise continues to default to detected number of
  logical processors
- Add run-query script to aid in testing and analyzing individual queries
- Update scripts to enable individual create-db scripts to decide whether a
  CREATE DATABASE command needs to be executed when running a test
- AppImage: bump touchstone-tools version to v0.9.1
- AppImage: add missing perl modules for flame graphs
- AppImage: add, again, python libraries for rst2html5 that were accidentally
  removed in v2.0.7

v2.0.8 (2024-08-14)

- Fix Makefile.cmake for running build-dbgen correctly
- AppImage: fix handling of default DSS_QUERY location

v2.0.7 (2024-08-12)

- Add power test geometric mean and throughput test arithmetic mean lines back
  on the query execution bar plot, lost when converted script to gnuplot
- Revert and update AppImage creation to use appimagetool again
- Tag AppImage binary for the DBMS that dbgen is build for, only if dbgen is
  build into the AppImage

v2.0.6 (2024-06-28)

- Fix use of --relax flag in run script
- Update use of touchstone scripts to call ts for stats collection
- pgsql: just ANALYZE, not VACUUM each table
- Fix run script to check and stop if output directory already exists
- pgsql: Load all the tables, build indexes and analyze in parallel as opposed
  to serially

v2.0.5 (2024-05-24)

- Add --relax flag to the run script so that load tests can be run to with
  relaxed adherence to the specification
- Fix post-process script to calculate min, max and average correctly

v2.0.4 (2024-04-21)

- pgsql-load-data: fix script to wait until VACUUM ANALYZE is done

v2.0.3 (2024-04-10)

- Set APPDIR in AppRun script to able to easier use an extracted AppImage
- Remove activate script, less to maintain and the AppRun can be used instead
- Create AppImage on Debian 10 (buster), previously Ubuntu 14.04 (Trust Tahr)
- Fix build-dbgen script to handle relative paths
- Allow creating AppImage built with TPC-H Tools binaries

v2.0.2 (2023-10-18)

- Remove fonts from AppImage; it was a partial solution so instead rely on
  font config and fonts to be installed on the host
- Fix report generation of sar data
- Update run script to take the tablespace directory as an argument instead of
  requiring the TSDIR environment variable be set
- Implement tablespaces for PostgreSQL indexes when tablespaces are used
- pgsql-load-data: add --relax argument to use indexes out of spec

v2.0.1 (2023-06-20)

- Update AppImage container file to use Ubuntu 14.04
- Add missing libraries to AppImage for gnuplot
- Add fonts to AppImage for gnuplot
- Replace readlink with realpath
- Quiet pgsql-report when database stats are not collected
- Quiet "report" script when system stats are not collected

v2.0.0 (2023-05-17)

- Fix post processing RST table format error when seed is too longer than 9
  digits
- Add updated TPC-H Tools patches for v3.0.1
- Remove TPC-H Tools patches for v3.0.0
- Fix PostgreSQL refresh streams scripts to run against remote as well as local
  database systems
- Update/rename docker scripts to also support podman
- Add container script to run a complete test
- Convert documentation to reStructuredText
- Add dbt3-build-dbgen script to build dbgen with applied patches
- Add ability to create an AppImage
- Rename run-workload script to "run"
- Don't create output directory until closer to starting the test
- Manage DSS_PATH, DSS_QUERY, and DSS_CONFIG environment variables in "run"
  script so that they only need to be directly managed by the user when running
  individual tools manually
- Generate PDF version of the report only when explicitly requested
- Stop double collecting stats in MonetDB and Virtuoso scripts
- Do not automatically create HTML report after test execution
- Set throughput streams per specification guidelines, if not explicitly
  overridden
- Use touchstone-tools for collecting system and database statistics, as well
  as system profile data
- Convert power-score script to use sqlite3
- Convert post-processing script to use sqlite3
- Add usage message to PostgreSQL scripts
- Add usage message to top level scripts
- Change "run" script usage and default for simpler usage
- Add "run" man page
- Make unprivileged user the default mode "run" script mode
- Replace some short options with long options
- Direct load database by default
- Add --scale-factor long option
- Add long options for test specific database parameters
- Save dbgen data generation output to files instead of streaming to stdout
- Save pgsql load output to files instead of streaming to stdout
- Rename generate-report script to simply "report"

v1.11.1 (2022-06-03)

- Fix logic for generating data files in load test script
- Add flag to run test as an unprivileged database super user
- Refactor getting PostgreSQL EXPLAIN ANALYZE output by using auto_explain
  extension and qgen facilities instead of duplicate query templates
- Add reporting of table and index stats back to PostgreSQL report
- Add header to PostgreSQL captured settings
- Generate only 1 memory file from sar if only 1 memory output format is
  recognized
- Add ignore file for Docker

v1.11.0 (2022-05-27)

- Add Docker files to run DBT-3 against PostgreSQL.
- Update reporting to generate HTML from ReStructuredText
- Add separate PostgreSQL reporting script
- Move seed generation back to after the load test
- Save the time when the test starts in config.txt
- Remove TPC dbgen code for TPC EULA 2.2 compliance
- Fix explain plan generation for throughput test
- Add instructions for how the user needs to add TPC dbgen manually
- Make use of qgen and dbgen more consistent in scripts
- Add patches that apply to dbgen for PostgreSQL support
- Parallelize PostgreSQL data load by number of detected processors, and load
  by table
- Add PostgreSQL query templates for EXPLAIN ANALYZE output
- Adopt Artistic License 2.0

v1.10

- Updated scripts to allow running against non-default ports for PostgreSQL.
- Updated database stat collection scripts for PostgreSQL.
- Improved load performance for PostgreSQL by putting the COPY command as
  part of the same transaction as the CREATE TABLE command.  v8.2 or newer
  required to take advantage of this.
- An assortment of script cleanups.
- Added some support for MySQL.  The scripts are not fully integrated yet.

v1.9

- Fixed a couple of parameter issues with scripts.
- Fixed the order of table names and index names when analyzing PostgreSQL
  database statistics.

v1.8

- Updated scripts/pgsql/create_tables.sh.in to not build primary keys when
  creating the tables.  Primary keys are created in
  scripts/pgsql/create_indexes.sh.in now.
- More cleaning up in the scripts.

v1.7

- Fixed release to include scripts/init_seed.sh.

v1.6

- Removed the builddb directory.  Subsequent releases should contain database
  building scripts int their respective database scripts directory.
- Removed the data_collect directory.  Subsequent releases should contain
  database data collection scripts int their respective database scripts
  directory.  Moved any general usage scripts into the scripts/ directory.
- Removed the dbdriver directory.  Subsequent releases should contain database
  driving scripts in their respective database scripts directory.
- Reorganized the datagen queries directory into a queries/ directory.
- Simplified the execution scripts.
- Reorganized the tree.
- Probably broke the scripts for SAP DB.
- Improved configure.ac (renamed from configure.in.)
- Removed building of dbgen from the Makefile.am until the makefile for dbgen
  can be adapted into automake.
- Stop calculating the power metric in perl and now in C.  It appeared that
  perl cannot calculate the metric if the numbers got too big.
- Renamed scripts/pgsql/get_power.pl to scripts/pgsql/get_power.sh and made it
  use q_time.sh output to calculate the power metric.
- Renamed scripts/pgsql/get_throughput.pl to scripts/pgsql/get_throughput.sh
  and made it use q_time.sh output to calculate the throughput metric.
- Improved usage for scripts/pgsql/start_db.sh.in.
- Modified scripts/pgsql/throughput_test.sh.in so it will exit and stop the
  test if a script fails.
- Fixed scripts/run_workload.sh.in