Scaling Postgres Episode 51 | Value of SQL | Window Functions | DB Migrations | Data Storage

In this episode of Scaling Postgres, we review articles covering the value of SQL, window functions, scaling database migrations and efficient data storage.

Content Discussed

• [YouTube] Breaking PostgreSQL at Scale
• SQL: One of the Most Valuable Skills
• How to Calculate a Cumulative Percentage in SQL
• What’s new in PostgreSQL 11
• Move fast and migrate things: how we automated migrations in Postgres
• Performance best practices for using Azure Database for PostgreSQL – Connection Pooling
• PostgreSQL Deep Dive: How Your Data Model Affects Storage
• FOSDEM PostgreSQL Track
• FOSDEM Databases Track
• [YouTube] What's new in PostgreSQL 11
• [YouTube] Deploying PostgreSQL on Kubernetes
• [YouTube] Hacking PostgreSQL
• [YouTube] Around the world with Postgres extensions
• [YouTube] Data Modeling, Normalization and Denormalization
• What’s up with SET TRANSACTION SNAPSHOT?
• An Overview of the Index Changes in PostgreSQL 11

YouTube Video