Citus: Sharding your first table
Here’s how to shard a table from scratch with Citus. Scale PostgreSQL DBs using a sharding approach. How to run a Citus Docker container.
This article covers scaling advices for PostgreSQL and explains why it may be a good idea to keep it simple on the database side.
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.
Scaling PostgreSQL: Using more than just one core for aggregation
Unfortunately PostgreSQL cannot scale a single query to more than one core. We have done some experiments to see how scaling up can work.