Sharding, Federation, Linux HugePages, Performance Tuning | Scaling Postgres 187
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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.notion.so/blog/sharding-postgres-at-notion
https://blog.crunchydata.com/blog/multi-cluster-postgres-federation-on-kubernetes-with-postgres-14-using-gitops
https://www.percona.com/blog/why-linux-hugepages-are-super-important-for-database-servers-a-case-with-postgresql/
https://www.enterprisedb.com/blog/webinar-recap-tuning-tips-maximize-postgres-performance
https://aws.amazon.com/blogs/database/tune-sorting-operations-in-postgresql-with-work_mem/
https://www.cybertec-postgresql.com/en/show-tables-in-postgresql-whats-wrong-with-it/
https://blog.rustprooflabs.com/2021/10/postgres-14-query-id
https://www.highgo.ca/2021/10/15/backup-label-in-postgresql/
https://www.postgresonline.com/journal/index.php?/archives/401-Multirange-types-in-PostgreSQL-14.html
https://fluca1978.github.io/2021/10/09/PostgreSQLOnOpenBSD.html
https://postgresql.life/post/sebastiaan_mannem/
Create your
podcast in
minutes
It is Free