PostgreSQL

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…

PostGIS Fundamentals

What is PostGIS and How is it Used? PostGIS is a PostgreSQL extension that adds embedded support for geospatial data. Instead of just treating latitude…