PGCon2018 - 2.5

PGCon 2018
The PostgreSQL Conference

Ilya Kosmodemiansky
Day Tutorials - Day 2 & Unconference: Wednesday - 2018-05-30
Room DMS 1150
Start time 13:00
Duration 03:00
ID 1211
Event type Lecture
Track Tutorial
Language used for presentation English

Linux IO internals for database administrators

Input-output performance problems are on every day agenda for DBAs since the databases exist. Volume of data grows rapidly and you need to get your data fast from the disk and moreover - fast to the disk. For most databases there is a more or less easy to find checklist of recommended Linux settings to maximize IO throughput. In most cases that checklist is good enough. But it is always better to understand how it works, especially if you run into some corner-cases.

This talk is about how IO in Linux works, how database pages travel from disk level to database own shared memory and back and what kind of mechanisms exist to control this. We will discuss memory structures, swap and page-out daemons, filesystems, schedulers and IO methods. Some fundamental differences in IO approaches between PostgreSQL, Oracle and MySQL will be covered