Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50
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-connection-pool.html
https://www.youtube.com/watch?v=kPhs-wdrb58
https://www.youtube.com/watch?v=1VWIGBQLtxo
https://www.percona.com/blog/2019/02/04/pg_repack-rebuild-postgresql-database-objects-online/
https://blog.2ndquadrant.com/postgresql-passphrase-protected-ssl-keys-systemd/
https://www.cybertec-postgresql.com/en/implementing-as-of-queries-in-postgresql/
https://brandur.org/sortsupport
Create your
podcast in
minutes
It is Free