Presented by:
Jan Wieck
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.
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.
- Date:
- 2018 April 18 12:30 EDT
- Duration:
- 50 min
- Room:
- Freedom
- Conference:
- PostgresConf US 2018
- Language:
- English
- Track:
- Postgres Internals
- Difficulty:
- Medium