← The Grounds Replication, Scaling & Cloud PostgreSQL Before you add infrastructure, make certain you have exhausted what PostgreSQL already provides. Replication, partitioning, cloud-specific tuning for RDS, Heroku, Supabase, and Neon — and the Redis workloads PostgreSQL handles natively.
1 PostgreSQL Replication: Streaming, Logical, and When to Use Each 2 pglogical vs Native Logical Replication in 2026: When to Migrate 3 PostgreSQL Scaling Decision Framework 4 pg_partman Alternatives: Your Table Does Not Need to Be Dismembered 5 PostgreSQL on AWS RDS: A Proper Optimization Guide 6 PostgreSQL on Heroku: Making Every Connection Count 7 PostgreSQL on Supabase: What the Defaults Leave on the Table 8 Neon PostgreSQL Performance: Optimizing for Serverless 9 Zero-Downtime Alembic Migrations on PostgreSQL: The Household Does Not Tolerate Outages 10 PostgreSQL LISTEN/NOTIFY, SKIP LOCKED, and UNLOGGED Tables as Redis Alternatives 11 PostgreSQL Caching Strategies Without Redis 12 PostgreSQL Job Queues with SKIP LOCKED: Replace Redis + Sidekiq 13 PostgreSQL Pub/Sub with LISTEN/NOTIFY: Replace Redis Pub/Sub