Vertical partitioning: 3 real scaling case studies
3 of the 94 engineering write-ups in our database are tagged with the technique "vertical partitioning". They come from 3 companies (Figma, GitHub and GitLab) and were published between 2021 and 2023. Stack that shows up most often in these stories: PostgreSQL (2) and Ruby on Rails (2). Each card below links to our short summary and the original post.
GitHub and GitLab are both Ruby on Rails apps: how they split the databases behind Rails.
The growing pains of database architecture
How Figma moved from one Postgres instance to multiple databases by vertically partitioning table groups.
We are splitting our database into Main and CI
GitLab.com split CI tables into their own Postgres database to relieve its main database.
Partitioning GitHub's relational databases to handle scale
GitHub defined schema domains and linted cross-domain queries so it could move table groups onto separate MySQL clusters.