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.