PGCon2019 - 3.4
PGCon 2019
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Tomas Vondra |
| Schedule | |
|---|---|
| Day | Tutorials - Day 1: Tuesday - 2019-05-28 |
| Room | DMS 1150 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| ID | 1416 |
| Event type | Workshop |
| Track | Tutorial |
| Language used for presentation | English |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
PostgreSQL Performance Tuning
A half-day training session focused on areas that you should master to tune PostgreSQL for performance. The training starts by explaining the overall architecture of the database system, how it interacts with the operating system and what settings are important; both in PostgreSQL and the operating system itself.
PostgreSQL is a multi-user system executing queries in parallel and it uses a fair amount of locking to co-ordinate those independent processes. As locks are a natural enemy of parallel systems, we'll spend some time explaining the basics of locking in PostgreSQL and how to investigate these issues. We'll also look at the basics of MVCC, a PostgreSQL feature that allows database systems to reduce the amount of locking. It's important to understand the basic MVCC idea as it has consequences for maintenance, particularly with regards to reclaiming space by VACUUM/autovacuum.
A list of topics to be covered will be added later today (2019.05.24).