PostgreSQL Performance

SQL Execution Hierarchy and Early Filtering with CTEs

When writing SQL queries, we write SELECT first, sprinkle in all the necessary aggregations and joins, mostly without considering what the database executes first. In…

How to Alter Large Tables Without Downtime

A story about adding a new column to a table with 600 million records The Challenge Picture this. You have a task to implement data…