Anniversary mailbag
Postgres FM
00:00
The Effect of WoW Log Hints Equals on After Bulk Deletes
The first question I had in the list was, what is the effect of wow log hints equals on after bulk deletes? Why does the next select one slow and generate tons of wool? So this one came in via Twitter. It's strange that while lock hints leads, I don't think there's connection here. But speaking of bulk deletes, I think the problem is not in while lock hints are maybe I'm wrong again. The problem itself is in bulk deletes themselves. Like if you delete a lot of tuples and then read from the same pages, some life type tuples or revisit like if indexes don't have version information. We need to split deletes and batches
Transcript
Play full episode
