Engineering
11 min read
Moving a 4 TB Postgres database without downtime
Logical replication, a 90 second switch window and the three extensions that almost stopped us.

Written by
Sam Okafor
Logical replication, a 90 second switch window and the three extensions that almost stopped us.
This is sample article text for the template. Replace it with your own post in the CMS: every paragraph, heading and list here is a normal rich text field.
What we measured
We pulled a year of invoices, split every line into compute, storage and traffic, and compared each account against its first full month on Aldridge.
Compute cost fell by a median of 22%
Storage cost was roughly flat
Traffic cost went to zero because egress is included
What we would do again
Keep the old stack running for a week, move one service at a time, and switch DNS last. Most of the risk in a migration is in doing everything at once.
Keep reading

Pricing
What our egress bill would have been
We ran the numbers on 1,140 accounts that moved from AWS. The median one was paying 31% of its bill for traffic leaving the cloud.

Reliability
How we test failover every Thursday
Every Thursday at 10am Eastern we fail over one Postgres cluster in each region on purpose. Here is what broke the first six times.

Company
Why we built in Columbus
Cheap power, a fiber crossroads and a lot of people who know how to run buildings. Our first region was not an accident.