Conference Schedule - PGCon 2022

CREATE INDEX CONCURRENTLY implementation details

Date: 2022-05-26
Time: 12:00–12:45
Room: Stream 3
Level: Intermediate

From the very beginning of 2021 until late summer, I was fixing a bug in CREATE INDEX CONCURRENTLY. This bug manifests extremely seldom. I could not find any traces of it in mailing lists ever since the introduction of the feature in 8.2. Yet the bug affected our systems, so I decided to fix it. This is how the detective bug-hunting story started. In this story, I'll share details of the implementation of transactions and lock mechanics. This knowledge may be of interest to DBA or hackers who want to go deeper into source code.


The following slides have been made available for this session:


Andrey Borodin