Citus live query inspection using citus_stat_activity
How to use citus_stat_activity to get all the the information about your database shards you need at once - makes it super easy to debug.
Citus: 7 commonly used advanced SQL tools
How to use 6 commonly-needed SQL tools in Citus. When you run advanced SQL in Citus, what's possible? What SQL statements work? Find out.
Data locality: Scaling PostgreSQL with Citus intelligently
How to use data locality to increase performance while sharding PostgreSQL data with Citus. What is database locality
This article covers scaling advices for PostgreSQL and explains why it may be a good idea to keep it simple on the database side.
PostgreSQL affiliate projects for horizontal multi-terabyte scaling
Don’t be afraid to scale up with Postgres: Overview about PostgreSQL extensions and derivatives for horizontal multi-terabyte scaling.
Ideas for scaling PostgreSQL to multi-terabyte and beyond
Features and "hacks" for scaling PostgreSQL to multi-terabyte and beyond. Ways to safely accommodate decent multi-terabyte size databases.
