To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
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.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:27 - Statement from the PostgreSQL Core Team on the EDB acquisition of 2ndQuadrant
01:17 - The Surprising Impact of Medium-Size Texts on PostgreSQL Performance
08:47 - zheap: Inspecting storage sizes
12:06 - Postgres 13 Performance with OpenStreetMap data
13:29 - TPC-H performance since PostgreSQL 8.3
15:08 - pg_rewind changes in PostgreSQL 13
16:23 - Data consistency issues in logical replication
18:27 - Logical Replication Upgrade in Postgres
18:59 - How to Upgrade PostgreSQL 11 to PostgreSQL 12 with Zero Downtime
19:18 - Using PostgreSQL to Shape and Prepare Scientific Data
19:57 - The way PG store null value in record
20:27 - Free Space Mapping file in details
20:38 - Damien Clochard
20:50 - Outro
#postgres #postgresql
16 июл 2024