Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116
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://medium.com/@rsbeoriginal/partitioning-with-postgresql-v11-6fe5388c6e98
https://medium.com/@rsbeoriginal/partitioning-with-postgres-v11-2-2-2619e024a23c
https://postgresql.life/post/paul_ramsey/
https://info.crunchydata.com/blog/spatial-constraints-with-postgis-part-1
https://www.highgo.ca/2020/05/29/mongodb-logical-decoding-plugin-first-community-release-on-github/
https://agroal.github.io/pgagroal/
Create your
podcast in
minutes
It is Free