Scaling Postgres Episode 187 Sharding | Federation | Linux HugePages | Performance Tuning

In this episode of Scaling Postgres, we discuss one method to shard a database, federating your database, the benefits of configuring linux HugePages and performance tuning.

Content Discussed

• Herding elephants: Lessons learned from sharding Postgres at Notion
• Multi-Cluster Postgres Federation on Kubernetes with Postgres 14 Using GitOps
• Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL
• Webinar Recap: Tuning Tips to Maximize Postgres Performance
• Tune sorting operations in PostgreSQL with work_mem
• SHOW TABLES in PostgreSQL: what’s wrong with it?
• Using Query ID in Postgres 14
• Backup Label in PostgreSQL
• Multirange types in PostgreSQL 14
• Installing PostgreSQL on OpenBSD
• Sebastiaan Mannem

YouTube Video