PhoenixKit.Migrations.Postgres.V93 (phoenix_kit v1.7.113)

Copy Markdown View Source

V93: Add prefix index on settings key column for integration queries.

The integrations system queries settings by key prefix (e.g., LIKE 'integration:google:%'). Without a supporting index, these queries cause full table scans. This migration adds a text_pattern_ops B-tree index that PostgreSQL can use for prefix LIKE queries.

All operations are idempotent.

Summary

Functions

down(opts)

up(opts)