You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This commit was created on GitHub.com and signed with GitHub’s verified signature.
Performance
Migration 7 adds fact_pull_requests(created_at DESC), so newest-first
pull-request listings stop sorting the whole table: on a 16 GB test
warehouse with nothing cached, the first page went from about 30 s to
24 ms. The index is descending on purpose. Pull requests that share a created_at keep the order the old scan-and-sort returned.
It also adds fact_pull_requests(author_key, created_date_key, repo_key, title), so per-author work lists over a date window (repository and title)
read only the index.
Upgrade notes
Migration 7 adds about 6 MB and builds in one transaction at first open.
Binaries older than 0.3.3 refuse an upgraded warehouse.