PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Amit Kapila
Day Talks - Day 4 - Friday - 2015-06-19
Room DMS 1160
Start time 11:00
Duration 00:45
ID 775
Event type Lecture
Track Performance
Language used for presentation English

Scalability and Performance Improvements in PostgreSQL

This paper will main talk about the scalability and performance improvements done in PostgreSQL 9.5 and will discuss about the improvements that can be done to improve the scalability for both Write and Read operations.

The paper will focus on pain points of Buffer Management in PostgreSQL and the improvements done in 9.5 to improve the situation along with performance data. It will also describe in brief the performance improvements done in 9.5. It will also discuss the locking bottlenecks due to various locks (lightweight locks and spinlocks) taken during Read operation and what could be done to further scale the Read operation.

The other part of the paper focusses on improving the Write-workload in PostgreSQL. In this part we will discuss about the frequency of writes done by backend operations (along with data) due to limitations of current bgwriter algorithm and some ideas to improve the performance by reducing writes done by backend. It will also discuss about the concurrency bottlenecks in write operation and some ideas to mitigate the same.