Scaling Postgres Episode 8 | Scaling Real-Time Analytics | Covering Indexes | 1,500 Upgrades
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL.
Content Discussed
- Building Real Time Analytics APIs at Scale
- idle_in_transaction_session_timeout: Terminating idle transactions in PostgreSQL
- Get rid of your unused indexes!
- Postgres 11 highlight - Covering Indexes
- PostgreSQL Bloatbusters.
- PostgreSQL Data Types: Date, Timestamp, and Time Zones
- The Ultimate Postgres vs MySQL Blog Post
- Postgres 10 Upgrade
- How to Perform Failover with the PostgreSQL Kubernetes Operator
- PostgreSQL Replication Failback with pg_rewind
YouTube Video
