In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, and how to tune max_wal_size.

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

Links for this episode:

• https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/
• https://aws.amazon.com/blogs/database/hidden-dangers-of-duplicate-key-violations-in-postgresql-and-how-to-avoid-them/
• https://www.cybertec-postgresql.com/en/pipeline-mode-better-performance-on-slow-network/
• https://www.enterprisedb.com/blog/tuning-maxwalsize-postgresql
• https://www.enterprisedb.com/blog/pg-phriday-wrapping-transactions-right-round
• https://www.endpointdev.com/blog/2022/03/using-pgtap-automate-database-testing/
• https://ctodive.com/hooks-the-secret-feature-powering-the-postgres-ecosystem-f05b3b82e0ba
• https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/
• https://pganalyze.com/blog/5mins-postgres-postgis-vs-gpu-citus-benchmarks-hammerdb
• https://www.highgo.ca/2022/03/18/distributed-database-with-postgresql-atomic-commit-problems/
• https://www.percona.com/blog/run-postgresql-on-kubernetes-with-percona-operator-pulumi
• https://blog.crunchydata.com/blog/spatial-filters-in-pg_featureserv-with-cql
• https://postgresql.life/post/jaime_casanova/
• https://www.rubberduckdevshow.com/episodes/34-real-world-performance-enhancements/