
Scaling Postgres Episode 39 | Bloat vs zHeap | Composite Indexes | Unsafe Operations
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering bloat vs. zheap, composite indexes, unsafe operations, and being a better developer.
Content Discussed
- Dealing with significant Postgres database bloat — what are your options?
- zheap: less bloat, fewer writes, and just plain smaller YouTube Video
- zheap: less bloat, fewer writes, and just plain smaller Slides
- How to use composite indexes to speed up time-series queries
- Safe and unsafe operations for high volume PostgreSQL
- Being a Better Developer With EXPLAIN - Louise Grandjonc
- Change Data Capture for a Brand New World - Hannu Valtonen
- Constraints: a Developer's Secret Weapon - Will Leinweber
- Triggers: Friends to Handle With Care - Charles Clavadetscher
- Preventing SQL Injections
- Zero downtime upgrade PostgreSQL 10 to 11.
- Five Cool Things I Learned at the PostgreSQL Conference Europe 2018