Data Corruption Bugs: Diagnosis and Lessons (PGConf.dev 2024)
Автор: PostgreSQL Development Conference
Загружено: 2024-06-24
Просмотров: 217
Описание:
A talk presented at PGConf.dev 2024 (https://2024.pgconf.dev)
Noah Misch presents: Data Corruption Bugs: Diagnosis and Lessons
Google Cloud SQL customers encounter PostgreSQL bugs corrupting databases, rarely but reproducibly. This talk will cover use of tools, especially amcheck, to grasp these bugs sufficiently to write fixes and test cases. Those fixes are now part of core PostgreSQL. It will include lessons for avoiding such bugs in future PostgreSQL development. Finally, it will share a diagnostic feature wish list.
https://www.pgevents.ca/events/pgconf...
Chapters
00:00 Introduction
02:36 amcheck btree walk-through
09:16 pageinspect
12:13 Defect case studies: pglogical internal
12:52 interval deduplication
18:01 PG_VERSION fsync
20:26 CREATE DATABASE, base backup
23:13 btree delete half-done
24:50 regexp \s changed behavior
29:25 GRANT, CREATE INDEX concurrency
38:17 bisect WAL
39:13 Wish list
41:57 Questions & answers
🎬 See more PGConf.dev 2024 videos • PGConf.dev 2024
Connect with us
X / pgconfdev
Mastodon: https://mastodon.social/@pgconfdev
Web: https://2024.pgconf.dev
#postgresql #PGConfdev #debugging
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
