Files
multica/server/migrations/440_github_pr_head_sha_index.up.sql
3fecc553e2 MUL-6786: index GitHub PR head SHA lookups (#7695)
* fix(db): index GitHub PR head SHA lookups

Co-authored-by: multica-agent <[email protected]>

* fix(db): narrow GitHub PR head SHA index

Co-authored-by: multica-agent <[email protected]>

---------

Co-authored-by: Sol-Boy <[email protected]>
Co-authored-by: multica-agent <[email protected]>
2026-08-28 17:02:57 +08:00

5 lines
265 B
SQL

-- Head SHA is selective enough to narrow the CI-webhook fallback to the few
-- mirrored rows whose installation and repository are then checked by SQL.
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_github_pull_request_head_sha
ON github_pull_request (head_sha);