Episode 207 Autovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/"> https://www.depesz.com/2022/03/13/is-my-autovacuum-configured-properly/</a></li> <li><a href= "https://aws.amazon.com/blogs/database/hidden-dangers-of-duplicate-key-violations-in-postgresql-and-how-to-avoid-them/"> https://aws.amazon.com/blogs/database/hidden-dangers-of-duplicate-key-violations-in-postgresql-and-how-to-avoid-them/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/pipeline-mode-better-performance-on-slow-network/"> https://www.cybertec-postgresql.com/en/pipeline-mode-better-performance-on-slow-network/</a></li> <li><a href= "https://www.enterprisedb.com/blog/tuning-maxwalsize-postgresql">https://www.enterprisedb.com/blog/tuning-maxwalsize-postgresql</a></li> <li><a href= "https://www.enterprisedb.com/blog/pg-phriday-wrapping-transactions-right-round"> https://www.enterprisedb.com/blog/pg-phriday-wrapping-transactions-right-round</a></li> <li><a href= "https://www.endpointdev.com/blog/2022/03/using-pgtap-automate-database-testing/"> https://www.endpointdev.com/blog/2022/03/using-pgtap-automate-database-testing/</a></li> <li><a href= "https://ctodive.com/hooks-the-secret-feature-powering-the-postgres-ecosystem-f05b3b82e0ba"> https://ctodive.com/hooks-the-secret-feature-powering-the-postgres-ecosystem-f05b3b82e0ba</a></li> <li><a href= "https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/"> https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-postgis-vs-gpu-citus-benchmarks-hammerdb"> https://pganalyze.com/blog/5mins-postgres-pos