low latency

Firmex is a provider of Virtual Data Rooms, opening over 20,000 new rooms annually and focusing on security and availability for clients during due diligence processes. The company previously managed around 65,000 databases across four Microsoft SQL Servers but faced challenges related to database limits, backups, and licensing terms. In 2020, engineers recognized they were nearing the maximum database limit and shifted from a database-based isolation model to a schema-based isolation approach using PostgreSQL. This transition involved collaboration with AWS to utilize Aurora PostgreSQL-Compatible Edition, which offered better performance and cost-effectiveness. The migration process required extensive work, including converting stored procedures and addressing data migration challenges such as endpoint and task limits with AWS DMS. Firmex's engineers developed custom tooling to manage the migration effectively, ensuring minimal downtime for customers. Post-migration, they have seen improved performance and reduced operating costs, with ongoing efforts to optimize their PostgreSQL utilization further.