Analyze routing table right after creating it
Problem
We need to analyze each routing table to make sure partitioning pruning is being done efficiently.
For this, we write the following migration:
disable_statement_timeout do
execute('ANALYZE VERBOSE p_ci_pipeline_variables;')
end
Solution
- Automate routing table analysis when creating our routing table