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