Last year we performed a huge data migration at Capacities. We moved our entire database system from a dedicated graph database to Postgres. While graph DBs are powerful, we found that for our scale the overhead was massive. By optimizing our data model in Postgres, we reduced database costs by 90% while making our database system more robust and scalable.

In this article, I walk through the process and the challenges we faced.