Conference Schedule - PostgresOpen 2017


Running Postgresql @ Instagram

Level: Intermediate

In this talk we will review how Instagram deployed its Postgresql cluster. From the early days Instagram relied on Django and Postgresql. The talk will present a brief history of our key optimizations and lessons learned, sometimes the hard way.
0. The start and monitoring 1. Vertical partitioning 2. Horizontal sharding 3. 2 layered Pooling 4. Slow transactions, idle in transaction, hot and vaccums 5. Regular migrations for upgrade / resharding 6. New slaves: leveraging streaming and wal storage 7. Read partitioning 8. Hot tuples and vaccums optimizations 9. Multi-region & cache invalidation


Francois Deliege