Scalable MVCC Solution for Many Core Machines 

by Dilip Kumar
In Current MVCC solution of PG, ProcArrayLock is the major bottleneck on many core machine 120+ and can scale up to 30 connections in TPCC test. Done experiment with lock free MVCC solution, and it can Scale up to 120 cores.
In Current MVCC solution of PG, ProcArrayLock is the major bottleneck on many core machine 120+ and can scale up to 30 connections in TPCC test. Done experiment with lock free MVCC solution, and it can Scale up to 120 cores.
We have taken the CSN based solution proposed in PG community, and implemented a lock free version of the same.
By considering the High Memory and other resources in many core machines, locks are avoided in all the performance patch and only in some rare paths locks are used.