
Scaling Postgres Episode 101 Postgres Releases | Useless Vacuum | Isolation Differences | WAL Compression
Get New Episodes Weekly!
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