pg_plan_advsr
pg_show_plans
Our great sponsors
pg_plan_advsr | pg_show_plans | |
---|---|---|
1 | 1 | |
87 | 176 | |
- | 1.7% | |
4.8 | 7.7 | |
almost 3 years ago | about 1 month ago | |
C | C | |
- | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_plan_advsr
-
Discussion: the feasubility of using open source hyperparameter optimization tools and SQLAlchemy to automatically tune database performance
Something along the lines of https://github.com/ossc-db/pg_plan_advsr sounds more promising.
pg_show_plans
What are some alternatives?
optuna - A hyperparameter optimization framework
pg_profile - Postgres historic workload reports
hyperopt - Distributed Asynchronous Hyperparameter Optimization in Python
pg_wait_sampling - Sampling based statistics of wait events
orafce - The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
plpgsql_check - plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
libfirm - graph based intermediate representation and backend for optimising compilers
bg_mon - Background worker for monitoring PostgreSQL
pgsentinel - postgresql extension providing Active session history
postgresql-unit - SI Units for PostgreSQL
pg-ulid - PostgreSQL extension for ULID