Files
multica/server/migrations/139_issue_description_trgm_index.up.sql
Multica Eve 75e8bd5b64 fix: make release index migrations concurrent (#4995)
Co-authored-by: Eve <eve@multica-ai.local>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-06 19:06:53 +08:00

5 lines
299 B
SQL

-- Fallback GIN index for SearchIssues description LIKE matches when pg_bigm is
-- not available. Single-statement file required for CREATE INDEX CONCURRENTLY.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_issue_description_trgm
ON issue USING gin (LOWER(COALESCE(description, '')) gin_trgm_ops);