Supabase Introduces Postgres Read Replicas
-
Supabase launched support for Postgres Read Replicas on 2023-12-15, offering database load distribution, data proximity, redundancy, and complex query execution without impacting primary databases.
-
Read replicas can only perform read operations, with asynchronous replication to minimize transaction blocking, however, they inherit the compute size of their primary.
-
The service simplifies horizontal database scaling across multiple databases and reduces primary database load, including the ability to designate replicas for analytics or launch them in different regions.
-
Supabase has automated most of the complexity associated with using read replicas, including management through the infrastructure settings page and visualizing SQL queries.
-
Read replicas are priced based on compute, storage, and WAL transfer, with the service planning to release automatic failover for all paid plans and database-level load balancing in the future.