PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
Speakers | |
---|---|
Dilip Kumar |
Schedule | |
---|---|
Day | Talks - Day 4 - Friday - 2015-06-19 |
Room | DMS 1120 |
Start time | 16:00 |
Duration | 00:45 |
Info | |
ID | 810 |
Event type | Lecture |
Track | Performance |
Language used for presentation | English |
Scalable MVCC Solution for Many Core Machines
In Current MVCC solution of PG, ProcArrayLock is the major bottleneck on many core machine(>120) and can scale upto 30 connections in TPCC test. Done experiment with lock free MVCC solution, and it can Scale upto 120 cores.
In Current MVCC solution of PG, ProcArrayLock is the major bottleneck on many core machine(>120) and can scale upto 30 connections in TPCC test. Done experiment with lock free MVCC solution, and it can Scale upto 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.