DenozordecandCursor
ee8e24ffc6
Индексы для diff/list префиксов и сортировки модулей; covering index для pagination. Co-authored-by: Cursor <cursoragent@cursor.com>
18 lines
725 B
SQL
18 lines
725 B
SQL
-- Query indexes: revision diff/list and module sort (H4 + M4).
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_rev_mat_prefix_rev_prefix
|
|
ON revision_materialized_prefix (revision_id, prefix);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_module_tenant_active_sort
|
|
ON module (tenant_id, priority, name)
|
|
WHERE deleted_at IS NULL;
|
|
|
|
-- Covering index for prefix list pagination (PostgreSQL 11+ INCLUDE).
|
|
DROP INDEX IF EXISTS idx_rev_mat_prefix_rev_id;
|
|
CREATE INDEX IF NOT EXISTS idx_rev_mat_prefix_rev_cover
|
|
ON revision_materialized_prefix (revision_id, id)
|
|
INCLUDE (prefix, community_id, source);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS idx_rev_mat_prefix_uniq
|
|
ON revision_materialized_prefix (revision_id, prefix, community_id, source);
|