In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.postgresql.org/about/news/statement-from-the-postgresql-core-team-on-the-edb-acquisition-of-2ndquadrant-2094/
https://hakibenita.com/sql-medium-text-performance
https://www.cybertec-postgresql.com/en/zheap-inspecting-storage-sizes/
https://blog.rustprooflabs.com/2020/10/postgres13-openstreetmap-performance
https://www.2ndquadrant.com/en/blog/tpc-h-performance-since-postgresql-8-3/
https://sql-info.de/postgresql/notes/pg-rewind-changes-in-postgresql-13.html
https://elephanttamer.net/?p=43
https://info.crunchydata.com/blog/logical-replication-upgrade-in-postgres
https://severalnines.com/database-blog/how-upgrade-postgresql-11-postgresql-12-zero-downtime
https://info.crunchydata.com/blog/1-using-postgresql-to-shape-and-prepare-scientific-data
https://www.highgo.ca/2020/10/20/the-way-to-store-null-value-in-pg-record/
https://www.highgo.ca/2020/10/23/free-space-mapping-file-in-details/
https://postgresql.life/post/damien_clochard/