Scaling PostgreSQL: Check your Vacuum!

Stas Panchenko
Mar 28 · 6 min read

Partitions

Checking if Auto Vacuum is running
Find blocked sessions

Going deeper into auto vacuum


Event Store

Moving to Postgres 10

Partition a measurement table by a date
We were getting a tad frustrated at this point

Anti-wraparound mechanism

In summary

Gett Engineering

Code, stories, tips, thoughts, experimentations from the day-to-day work of our R&D team.

Thanks to Noam Kachko, Izik Shushan, Shai Mishali, and Andrey Eidelman.

Stas Panchenko

Written by

Senior Backend Engineer @ Gett. Coding ninja and passionate about technology. 👾

Gett Engineering

Code, stories, tips, thoughts, experimentations from the day-to-day work of our R&D team.