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
Get New Episodes Weekly!
