Scaling Postgres

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