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.
Смотрите видео Scalable MVCC Solution for Many Core Machines онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Andrea Ross 11 Июль 2015, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42 раз и оно понравилось людям.