Scaling Postgres Episode 54 | Index-Only Scans | Lock Table | Hot Standby Feedback | Large Backups

In this episode of Scaling Postgres, we review articles covering index-only scans, locking tables, hot standby feedback and handling very large backups.

Content Discussed

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use
Index-only scans in Postgres
“LOCK TABLE” can harm your database’s health
I Fought the WAL, and the WAL Won: Why hot_standby_feedback can be Misleading
PostgreSQL Tools for the Visually Inclined
Managing PostgreSQL backups and replication for very large databases — Part 2
How ShiftLeft Uses PostgreSQL Extension TimescaleDB
Settling the Myth of Transparent HugePages for Databases
Benchmark PostgreSQL With Linux HugePages