Scaling Postgres

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-po