Deploy PGSQL Basic PGSQL Offline Replica PGSQL Standby Replica PGSQL Delayed Replica PGSQL Standby Cluster Citus Deployment MatrixDB Deployment PGSQL File Hierarchy Structur...

Common Error Messages Could not receive query results Resolution Canceling the transaction since it was involved in a distributed deadlock Resolution Could not connect to serve...

SQL Support and Workarounds Workarounds Work around limitations using CTEs Temp Tables: the Workaround of Last Resort SQL Support and Workarounds As Citus provides distribute...

Choosing Distribution Column Multi-Tenant Apps Best Practices Real-Time Apps Best Practices Timeseries Data Best Practices Table Co-Location Data co-location in Citus for has...

Sharding Postgres with Semi-Structured Data and Its Performance Implications One large table, without joins Enter Citus The query workload Every distribution has its thorns ...

Forking How to Fork a Formation When is it Useful How it Works Internally Followers Note We are no longer onboarding new users to Citus Cloud on AWS. However, existing custo...

Backup, Availability, and Replication High-Availability (HA) Replication Disaster Recovery (DR) Comparison of HA and DR Disaster Recovery takes a little extra work but gives grea...

Extensions Note We are no longer onboarding new users to Citus Cloud on AWS. However, existing customers can continue to use Citus Cloud as they do today. Extensions To keep a...

Ruby on Rails Preparing to scale-out a multi-tenant application Updating the Rails Application Updating the Test Suite Continuous Integration Example Application Ruby on Ra...

Overview Pigsty Features Get Started Architecture More Clusters OPTIONAL delayed cluster for pg-meta About Overview What is Pigsty? Pigsty “P ostgreSQL I n G reat STY ...