Talks
Upcoming Talks
Currently, no talks planed.
Previous Talks
How we execute PostgreSQL major upgrades at GitLab, with zero downtime
Upgrading your high available, high load PostgreSQL databases can be a challenge own its own. When having customers around the globe with tight SLAs, the requirement arises to execute these upgrades with minimal or even without any downtime.
This talk walks through how we at GitLab evolved from multihour downtime windows to not causing any customer facing interference at all.
- How we execute PostgreSQL major upgrades at GitLab, with zero downtime at PGConf.EU 2023
- Slides
- Video
PostgreSQL at GitLab.com
Welcome to the architecture of GitLab. In our talk, we will present the topology of our database ecosystem with PostgreSQL and how we manage to support over 60k TPS on the master and >1M TPS in total. Our goals are to maintain high availability of the database and still implement new features.
If you have seen the previous talk at PGConf.DE 2022 [1], you might be interested to learn about the outcome of the in flight decomposition project shown there.
An Elephants Habitat
With the broad adoption of PostgreSQL in enterprise and cloud environments the elephant needs more and more specialized and sophisticated tools to meet all the challenges in those new shiny habitats. Those challenges require the integration and operating of tools for backups, monitoring, operating, high availability, upgrades and many many more. Even small setups requires administrators to think about all the possible open source tools available to implement their requirements.
This talk gives an overview about all the challenges involved here and tries to give an idea about possible solutions. One example is the elephant-shed project, which shows a possible way on how to build an integrated operating layer which combines many specialized open source tools under a single roof.
PostgreSQL und alles was dazugehört - Elephant Shed (GERMAN)
PostgreSQL ist für viele Nutzer heute ein zentrales Element ihrer IT-Infrastruktur, oder auf dem Weg dahin. Für einen reibungslosen Betrieb wird jedoch eine entsprechende leistungsfähige Umgebung benötigt. Im Vortrag wird eine Stand-Alone-Datenbankserver-Umgebung vorgestellt, die für Entwicklung und Produktion verwendet werden kann und sowohl PostgreSQL-Neueinsteigern, -Umsteigern, als auch Veteranen das Leben möglichst einfach macht. https://elephant-shed.io/