Add get_system_characteristics function
In this PR:
- Add
get_system_characteristics
function
This function automatically detects, how many CPU cores are available to the Docker container, huw much GBs of RAM, and whether disks are "rotational" (HDD), or not (SSD).
- Basic autotuning steps
Add basic autotuning (only 'oltp' at the moment) for knobs: - shared_buffers - effective_cache_size - random_page_cost
- Fix order of actions when changing Postgres config
There was a logical error in determining, if Postgres restart is needed.
- Add order to pg_stat_*** artifacts (CSV files)
TODO:
-
auto-tuning for olap
workload -
more knobs to tune