I can do a USE_CONTENT_LOCK run on 0003 if it is something for 9.6.
Yes please. I think the lock variant is realistic, the lockless did
isn't.
I have done a run with -M prepared on unlogged running 10min per data point, up to 300 connections. Using data + wal on HDD.
I'm not seeing a difference between with and without USE_CONTENT_LOCK -- all points are within +/- 0.5%.
Let me know if there are other tests I can perform
How do either compare to just 0002 applied?
0001 + 0002 compared to 0001 + 0002 + 0003 (either way) were pretty much the same +/- 0.5% on the HDD run.
I think the main reason why there is no significant gain shown in your tests is that on the m/c where you are testing the contention due to CLOGControlLock is not high enough that any reduction on the same will help. To me, it is visible in some of the high-end machines like which have 4 or more sockets. So, I think these results should be taken as an indication that there is no regression in the tests performed by you.