Evolution of the PostgreSQL Storage for Listings at Avito

on YouTube ↗51m

" summary

A postmortem-style case study of Avito’s high-load PostgreSQL storage for listings, describing how the team handled large growth in traffic and data without sharding, the database outages and degradations that occurred, design mistakes made, the fixes applied, and the key operational change that stabilized the system while repairs were underway.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 6:14Lock contention
3. 16:47Disk issues and partitioning
4. 25:56Partitioning crashes
5. 32:25Final survival fight
6. 39:05Summary
7. 40:30Q&A

" related talks

• 31mImplementing Disaster RecoverySergey Burladyan · HighLoad++ 2015
• 01h 50mLogical Replication and AvitoK.Evteev, M.Tyurin, S.Burladyan · HighLoad++ 2017
• 46mBig databases, many servers, data center or cloud - it's all here!Flavio Gurgel · Devoxx France 2021
• 01h 04mStylish ScalingValentine Gogichashvili · HighLoad++ 2014
• 54mBreakout SessionMatthew Kelly · PGConf Silicon Valley 2015
• 43mJust Use Postgres.Rhys Elsmore · PyCon Australia 2015
• 49mLessons from Migrating a 10 TB PostgreSQL Cluster to AWSAleksandr Kukushkin · HighLoad++ Moscow 2018
• 20mBuild Your Business Based On PostgreSQL DatabasesBob Wuisman, Alan Palacio · Citus Con: An Event for Postgres 2022