PostgreSQL

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…