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.
