Scaling Postgres

Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

Informações:

Synopsis

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-prepar