Faster Index Creation | Scaling Postgres 326

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/326-faster-index-creation/

In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Timestamps:
00:00 - Intro
00:35 - Speeding up index creation in PostgreSQL
04:36 - Wait a minute! — PostgreSQL extension pg_wait_sampling
07:18 - pg_statviz 0.7 released with new features, PG17 support
07:54 - Row pattern recognition feature for PostgreSQL
11:37 - You make a good point! — PostgreSQL Savepoints
13:05 - PostgreSQL Subtransactions Considered Harmful
13:23 - Magic Tricks for Postgres psql: Settings, Presets, Echo, and Saved Queries
14:42 - Out of disk
17:46 - Which cloud providers support auto_explain?
18:27 - How and when to use btree_gist
19:47 - [YouTube] PGConf.dev 2024
20:01 - Outro

#postgres #postgresql

Тэги:

#PostgreSQL #Scaling_PostgreSQL #PostgreSQL_Performance

Скачать видео