Scaling Postgres Episode 101 Postgres Releases | Useless Vacuum | Isolation Differences | WAL Compression

In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files.

Content Discussed

• PostgreSQL 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 Released!
• [Postgres] Roadmap
• Useless Vacuuming
• Isolation Repeatable Read in PostgreSQL versus MySQL
• Compression of PostgreSQL WAL Archives Becoming More Important
• Configuring work_mem in Postgres
• Quickly Load CSVs Into PostgreSQL Using Python and Pandas
• Why Dropping a Column does not Reclaim Disk Space? (or better, why is it so fast?)
• Migrating from MS SQL to PostgreSQL: Uppercase vs. Lowercase
• How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
• Failover & Recovery with Repmgr in PostgreSQL 11
• Can PgBouncer survive transient network events?
• How to map a PostgreSQL ARRAY to a Java List with JPA and Hibernate

YouTube Video