feat(prepare-db): add helper functions for generic plan collection, with optional HypoPG index; wrap each prepare-db step in begin/commit block; introduce "postgres_ai" schema
- Add
postgres_aischema for organizing our objects - Move
pg_statisticview frompublictopostgres_aischema - Add
postgres_ai.explain_generic()function (SECURITY DEFINER) for collecting generic query plans with optional HypoPG index testing - Update search_path to include
postgres_aifirst - Change transaction model to wrap each step in its own
begin/commitinstead of grouping non-optional steps in a single transaction - Update verification to check for
postgres_aischema and new function
Relates to: #68 (closed)
Edited by Nikolay Samokhvalov