mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-27 21:33:41 +02:00
75e8bd5b64
Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
5 lines
273 B
SQL
5 lines
273 B
SQL
-- Fallback GIN index for SearchProjects title LIKE matches when pg_bigm is not
|
|
-- available. Single-statement file required for CREATE INDEX CONCURRENTLY.
|
|
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_project_title_trgm
|
|
ON project USING gin (LOWER(title) gin_trgm_ops);
|