Summary: tuning agent training is now migrated and stably running.
Demo:
Run pat_create_tgz.sh, install pg_hint_plan.so, and run pat_test.sh to reproduce.
No crashes after 8 minutes of running and 3 completed trials:
Details:
Standardized all paths to be Path objects instead of strings.
Cleaned up the default_*_path variables in misc/utils.py by categorizing them and making them take in the workspace path as an arg instead of the symlinks path.
Removed various hardcoded values such as the name of the postgres database and the query_directory path by consolidating them with other values (like CLI args or config files).
The .tgz file is created manually with pat_create_tgz.sh. This will be automated in the future.
pg_hint_plan.so is installed manually and moved into postgres/lib/ manually. This will be automated in the future.
Summary: tuning agent training is now migrated and stably running.
Demo:
Run
pat_create_tgz.sh, installpg_hint_plan.so, and runpat_test.shto reproduce.No crashes after 8 minutes of running and 3 completed trials:
Details:
Pathobjects instead of strings.default_*_pathvariables in misc/utils.py by categorizing them and making them take in the workspace path as an arg instead of the symlinks path.query_directorypath by consolidating them with other values (like CLI args or config files)..tgzfile is created manually withpat_create_tgz.sh. This will be automated in the future.pg_hint_plan.sois installed manually and moved intopostgres/lib/manually. This will be automated in the future.