PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
Speakers | |
---|---|
Amit Kapila |
Schedule | |
---|---|
Day | Talks - Day 4 - Friday - 2015-06-19 |
Room | DMS 1160 |
Start time | 11:00 |
Duration | 00:45 |
Info | |
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.