Database performance tuning

pg_plan_advice reproduces a Postgres plan by forbidding the planner's other options

PostgreSQL 19's new module prints a plan advice string out of EXPLAIN and replays it on later runs. Its own documentation warns that a pinned plan can turn very poor once the data distribution moves.