Understanding PostgreSQL IO
Jan Wieck is a former member of the PostgreSQL core team.
He designed and implemented Slony, overhauled the query rewrite rule system, wrote the procedural languages PL/pgSQL and PL/Tcl, added foreign keys, bgwriter, the statistics collector, the TOAST system and other features.
No video of the event yet, sorry!
Like any database, PostgreSQL is very dependent on the system's IO. In many situation's a poor performing database is directly related to how PostgreSQL is reading or writing to the disk and using memory. A key factor in improving performance is understanding how PostgreSQL is interacting with these resources.
In this talk I will discuss the interactions between shared buffers, OS buffers, WAL buffers, temporary files, kernel tuning parameters and more.
- 2018 April 18 12:30
- 50 min
- PostgresConf US 2018
- Postgres Internals