Scaling Postgres

In this episode of Scaling Postgres, we review articles covering an outage from running out of TXIDs, breaking scale, that PG fsync issue and pg_stat_statements. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://mailchi.mp/953cb079837a/important-information-about-an-ongoing-mandrill-outage https://mailchi.mp/436dba04bd62/update-on-the-mandrill-outage-service-restored https://twitter.com/mandrillapp/status/1092926493548834817 https://thebuild.com/blog/2019/02/08/do-not-change-autovacuum-age-settings/ https://andreas.scherbaum.la/blog/archives/970-How-long-will-a-64-bit-Transaction-ID-last-in-PostgreSQL.html https://www.postgresql.org/docs/11/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND https://postgresql.verite.pro/blog/2019/02/08/open-instances.html https://thebuild.com/presentations/2019-fosdem-broken.pdf https://www.citusdata.com/blog/2019/02/08/the-most-useful-postgres-extension-pg-stat-statements/ https://pgdash.io/blog/pgbouncer-connectio