Schedule - pgDay Paris 2025
Explore the role of PostgreSQL in GitLab ecosystem
Date: 2025-03-20
Time: 16:25–17:10
Room: Auditorium
GitLab is one of the leading DevOps platforms, empowering teams to collaborate effectively throughout the entire software development lifecycle. With over 40 milions registered users, this open-source project had to find a way how to store their data and combine diverse types of data storage. At the heart of this robust architecture lies the most popular database for the second year in a row in StackOverflow developer survey - PostgreSQL. This talk presents findings from a database-focused reverse engineering of the GitLab project (version 16.6). Attendees will gain insights into:
- The role of PostgreSQL in the GitLab architecture.
- An overview of PostgreSQL-related technologies GitLab uses to serve milions of users.
- Database schema design and its connections to the ways of deployment offered by GitLab.
- The best practises GitLab follows to keep the app and database up and running.
- PostgreSQL extensions, indexes, and core principles utilized by GitLab.
- How GitLab effectively executes and optimizes queries from the application layer.