| 1 | -- What a self-hosted runner can take, asked on every poll: queued jobs with |
| 2 | -- labels in its workspace, matched without regard to case. By the |
| 3 | -- lowercased namespace, so the match is a range of the index rather than |
| 4 | -- every labelled job. |
| 5 | CREATE INDEX IF NOT EXISTS jobs_self_hosted_lower ON jobs (lower(namespace), status) WHERE labels IS NOT NULL; |