Episode 187 Sharding | Federation | Linux HugePages | Performance Tuning

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.notion.so/blog/sharding-postgres-at-notion">https://www.notion.so/blog/sharding-postgres-at-notion</a></p> <p><a href= "https://blog.crunchydata.com/blog/multi-cluster-postgres-federation-on-kubernetes-with-postgres-14-using-gitops"> https://blog.crunchydata.com/blog/multi-cluster-postgres-federation-on-kubernetes-with-postgres-14-using-gitops</a></p> <p><a href= "https://www.percona.com/blog/why-linux-hugepages-are-super-important-for-database-servers-a-case-with-postgresql/"> https://www.percona.com/blog/why-linux-hugepages-are-super-important-for-database-servers-a-case-with-postgresql/</a></p> <p><a href= "https://www.enterprisedb.com/blog/webinar-recap-tuning-tips-maximize-postgres-performance"> https://www.enterprisedb.com/blog/webinar-recap-tuning-tips-maximize-postgres-performance</a></p> <p><a href= "https://aws.amazon.com/blogs/database/tune-sorting-operations-in-postgresql-with-work_mem/"> https://aws.amazon.com/blogs/database/tune-sorting-operations-in-postgresql-with-work_mem/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/show-tables-in-postgresql-whats-wrong-with-it/"> https://www.cybertec-postgresql.com/en/show-tables-in-postgresql-whats-wrong-with-it/</a></p> <p><a href= "https://blog.rustprooflabs.com/2021/10/postgres-14-query-id">https://blog.rustprooflabs.com/2021/10/postgres-14-query-id</a></p> <p><a href= "https://www.highgo.ca/2021/10/15/backup-label-in-postgresql/">https://www.highgo.ca/2021/10/15/backup-label-in-postgresql/</a></p> <p><a href= "https://www.postgresonline.com/journal/index.php?/archives/401-Multirange-types-in-PostgreSQL-14.html"> https://www.postgresonline.com/journal/index.php?/archives/401-Multirange-types-in-PostgreSQL-14.html</a></p> <p><a