In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge command and how to contribute to Postgres.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://www.enterprisedb.com/blog/harnessing-shared-buffers-part-2
• https://pganalyze.com/blog/5mins-postgres-tuning-shared-buffers-pgbench-TPROC-C-TPROC-H
• https://www.enterprisedb.com/blog/you-can-now-pick-your-favorite-compression-algorithm-your-wals
• https://www.enterprisedb.com/blog/merge-command
• https://postgres.fm/episodes/contributing-to-postgres
• https://supabase.com/blog/postgresql-commitfest
• http://peter.eisentraut.org/blog/2022/10/25/postgresql-15-statistics
• https://www.highgo.ca/2022/10/28/cross-partition-uniqueness-guarantee-with-global-unique-index/
• https://www.crunchydata.com/blog/postgres-databases-and-schemas
• https://www.crunchydata.com/blog/easier-upgrades-and-image-management-for-postgres-in-kubernetes
• https://postgresml.org/blog/postgresml-is-8x-faster-than-python-http-microservices/
• https://www.crunchydata.com/blog/moving-objects-and-geofencing-with-postgres-postgis
• https://blog.rustprooflabs.com/2022/10/pgrouting-lines-through-polygons
• https://www.cybertec-postgresql.com/en/postgis-upgrade-geos-with-ubuntu-in-3-steps/
• https://www.citusdata.com/blog/2022/10/21/postgres15-available-in-azure-cosmos-db-for-postgresql/
• https://devblogs.microsoft.com/cosmosdb/distributed-postgresql-comes-to-azure-cosmos-db/
• https://azure.microsoft.com/en-us/products/cosmos-db/#overview
• https://postgresql.life/post/etienne_bersac/
• https://www.rubberduckdevshow.com/episodes/63-halloween-party-with-coding-horror-stories/