Postgres at Any Scale

Explore the fundamentals of PostgreSQL database management and scalability in this 46-minute conference talk from EuroPython 2018. Begin with essential knowledge for app developers on database interactions, then delve into performance analysis techniques. Learn crucial aspects for small applications and discover key considerations as your database grows, including cache hit ratio, index hit ratio, proper indexing strategies, managing bloat, implementing efficient joins, and sharding techniques. Gain valuable insights to optimize PostgreSQL performance across various scales of operation.