Database

Our Journey to PostgreSQL 12

In November 2020 we began a large migration to upgrade our PostgreSQL cluster from version 9.6 to 12.4. In…

“DataError: Integer out of range” on Postgres. What to do next?

Yes, you read that right.

One fateful evening at 7p.m. our error rates began to spike. Inserts on our Postgres database were erring out and we were shocked to find our error logs overloaded with…

Reaching the Max Limit for Ids in Postgres

Databases and their limitations can be the source of interesting engineering challenges. One such challenge we recently faced as a team was dealing with the limitation of the int datatype on an auto incrementing primary key for a fast growing table in…