Scaling Postgres Episode 116 Observer Effect | Partition Management | Tuple Freezing | Hung Transactions

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

YouTube Video