Presented by:

6a3250c145ac64df9e22cede34791623

Jan Wieck

OpenSCG Inc.

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!
Download the Slides

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
Duration:
50 min
Room:
Freedom
Conference:
PostgresConf US 2018
Language:
English
Track:
Postgres Internals
Difficulty:
Medium