On 2020-Nov-16, Dmitry Dolgov wrote: > The same with reindex without locks: > > nsecs : count distribution > 512 -> 1023 : 0 | | > 1024 -> 2047 : 111345 | | > 2048 -> 4095 : 6997627 |****************************************| > 4096 -> 8191 : 18575 | | > 8192 -> 16383 : 586 | | > 16384 -> 32767 : 312 | | > 32768 -> 65535 : 18 | | > > The same with reindex with locks: > > nsecs : count distribution > 512 -> 1023 : 0 | | > 1024 -> 2047 : 59438 | | > 2048 -> 4095 : 6901187 |****************************************| > 4096 -> 8191 : 18584 | | > 8192 -> 16383 : 581 | | > 16384 -> 32767 : 280 | | > 32768 -> 65535 : 84 | | > > Looks like with reindex without locks is indeed faster (there are mode > samples in lower time section), but not particularly significant to the > whole distribution, especially taking into account extremity of the > test.
I didn't analyze these numbers super carefully, but yeah it doesn't look significant. I'm looking at these patches now, with intention to push.