Citus Extension in Cloud SQL Postgres

Google Cloud Database
1

Hi,

We are looking for a solution to evolve our DB to support sharding and horizontal scaling. We currently use CloudSQL Postgres. I couldn’t find anything about enabling Citus for CloudSQL. Our DB loads constantly increase, and scaling up Vertically causes downtime which is not suitable for our range of applications. Additionally, it’s a multi-tenant SAAS, so as data is building up - performance degradation can be observed and sharding is the next logical move. But couldn’t find any good reads on that as well.

Any pointers or alternate solutions (other than switching from CloudSQL to an alternate product or self-managed Postgres)

2

Hi,

CloudSQL doesn’t support the Citus Extension. If you workloads require columnar support you might want consider migrating from CloudSQL-PG to AlloyDB. You can do this seamlessly and with minimal downtime using the Database Migration Services.