In November 2020 we began a large migration to upgrade our PostgreSQL cluster from version 9.6 to 12.4. In…
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…
In my previous post, I discussed the importance of monitoring tables to ensure we don’t unknowingly hit database limits and different approaches for performing a Primary Key migration, including time estimates based…
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…
int