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