A developer shares their experience switching from MySQL to PostgreSQL using PlanetScale's new PostgreSQL offering. The move was driven by PlanetScale's Metal infrastructure using local NVMe drives, which provides significantly better performance than traditional cloud database solutions. The article includes detailed benchmarks comparing PlanetScale PostgreSQL against competitors like Neon, Aurora, and Supabase, showing 2-20x performance improvements. The switch was particularly beneficial for Convex, which needed multi-database support per instance for their multi-tenant architecture. The performance gains come from PlanetScale's use of local NVMe storage instead of network-attached storage, combined with their Vitess-based replication and failover capabilities.

26m watch time
3 Comments

Sort: