
Scaling Postgres Episode 116 Observer Effect | Partition Management | Tuple Freezing | Hung Transactions
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions.
Content Discussed
- Explain Analyze May Be Lying To You
- Partition management – do you really need a tool for that?
- SQL trickery: Configuring windowing functions
- Webinar: Tuple Freezing & Transaction Wrap around Through Pictures [Follow Up]
- Don't Leave Me Hanging: Another Type of Transaction to Monitor
- A multi-node, elastic, petabyte scale, time-series database on Postgres for free
- WAL, LSN and File Names
- Inspecting Command Tags and Events in event triggers
- Upgrading Postgres & Lessons Learned
- Partitioning with PostgreSQL v11 (1/2)
- Partitioning with Postgres v11 (2/2)
- Paul Ramsey
- Spatial Constraints with PostGIS - Part 1
- MongoDB Logical Decoding Plugin – First Community Release on GitHub
- PGAGROAL