UPGRADING REDSHIFT FROM RA3 TO RG AND ACHIEVING FASTER QUERIES AT 32% LOWER COST

Summary from the TLDR Data newsletter

Halodoc migrated its Redshift warehouse from RA3 to Graviton-based RG instances after validating ingestion, ETL, dashboards, and governance compatibility. COPY operations ran roughly 6x faster, heavy reporting queries ran 2.1x to 5.2x faster, and queue times fell by around 70%. Overall Redshift costs dropped 32%, demonstrating the potential benefits of the new architecture for production analytics workloads.