Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to start logical replication and configuring background workers.

Content Discussed

• The Integer at the End of the Universe: Integer Overflow in Postgres
• Can we make permissions management more user-friendly?
• Starting PostgreSQL logical replication for some tables based on a dump
• Workers of the World, Unite!
• Postgres 16 highlight - More regexps in pg_hba.conf
• Stored procedures in PostgreSQL: getting started
• PGSQL Phriday #006
• One Thing You Wish You Knew While Learning PostgreSQL: PGSqlPhriday #006
• What I Wish I Had Known About PostgreSQL
• One Thing You Wish You Knew While Learning PostgreSQL
• Postgres documentation explained
• psql Tips
• Geocoding with Web APIs in Postgres
• Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics
• How Postgres DBAs can use pg_stat_io
• European Route Planning
• TOAST
• Thom Brown
• Failing In Public | Rubber Duck Dev Show 76

YouTube Video