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

<p>In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.ongres.com/blog/explain_analyze_may_be_lying_to_you/">https://www.ongres.com/blog/explain_analyze_may_be_lying_to_you/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/partition-management-do-you-really-need-a-tool-for-that/"> https://www.cybertec-postgresql.com/en/partition-management-do-you-really-need-a-tool-for-that/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/sql-trickery-configuring-windowing-functions/"> https://www.cybertec-postgresql.com/en/sql-trickery-configuring-windowing-functions/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/webinar-tuple-freezing-transaction-wrap-around-through-pictures-follow-up/"> https://www.2ndquadrant.com/en/blog/webinar-tuple-freezing-transaction-wrap-around-through-pictures-follow-up/</a></p> <p><a href= "https://richyen.com/postgres/2020/05/25/dont-leave-me-hanging.html"> https://richyen.com/postgres/2020/05/25/dont-leave-me-hanging.html</a></p> <p><a href= "https://blog.timescale.com/blog/multi-node-petabyte-scale-time-series-database-postgresql-free-tsdb/"> https://blog.timescale.com/blog/multi-node-petabyte-scale-time-series-database-postgresql-free-tsdb/</a></p> <p><a href= "https://fluca1978.github.io/2020/05/28/PostgreSQLWalNames.html">https://fluca1978.github.io/2020/05/28/PostgreSQLWalNames.html</a></p> <p><a href= "https://fluca1978.github.io/2020/05/26/PostgreSQLEventTriggerDemo.html"> https://fluca1978.github.io/2020/05/26/PostgreSQLEventTriggerDemo.html</a></p> <p><a href= "https://medium.com/mode-engineering/upgrading-postgres-lessons-learned-7424a2467fdb"> https://medium.com/mode-engineering/upgrading-postgres-lessons-learned-7424a2467fdb</a></p> <p><a href= "https://medium.com/@rsbeoriginal/partitioning-with-postgresq