mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-23 10:08:38 +02:00
75e8bd5b64
Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
6 lines
288 B
SQL
6 lines
288 B
SQL
-- Fallback GIN index for SearchIssues comment content LIKE matches when
|
|
-- pg_bigm is not available. Single-statement file required for CREATE INDEX
|
|
-- CONCURRENTLY.
|
|
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_comment_content_trgm
|
|
ON comment USING gin (LOWER(content) gin_trgm_ops);
|