Scaling Postgres Episode 50 | Outage from TXIDs | Breaking Scale | fsync Gate | pg_stat_statements
Get New Episodes Weekly!
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.
Content Discussed
- MailChimp Outage Message 1
- MailChimp Outage Message 2
- MainChimp Twitter Status
- Do not change autovacuum age settings
- How long will a 64 bit Transaction-ID last in PostgreSQL?
- PG Docs: Preventing Transaction ID Wraparound Failures
- Postgres instances open to connections from the Internet
- Breaking PostgreSQL at Scale
- The most useful Postgres extension: pg_stat_statements
- PostgreSQL Connection Pooling with PgBouncer
- [YouTube] PostgreSQL Goes to 11!
- [YouTube] PostgreSQL vs. fsync
- Using pg_repack to Rebuild PostgreSQL Database Objects Online
- PostgreSQL with passphrase-protected SSL keys under systemd
- Implementing “AS OF”-queries in PostgreSQL
- SortSupport: Sorting in Postgres at Speed
YouTube Video
