Conference Schedule - PGCon 2020

Back

Mechanical Sympathy for Elephants: Reducing I/O and Memory Stalls

Date: 2020-05-28
Time: 09:00–09:45
Room: Stream 3
Level: Intermediate

This talk looks at the mechanics of memory and storage, and discusses a selection of opportunities for PostgreSQL to reduce stalls and improve performance. These include experimental and committed work done in the PostgreSQL and OS communities, along with some relevant ideas and observations found in academic papers. The following topics will be covered:

  • avoiding I/O stalls in recovery, index scans and joins
  • limiting I/O streams for parallel queries and concurrent queries
  • avoiding memory stalls for hash joins, sequential scans, index searches
  • avoiding branches through inlining and specialisation
  • reducing TLB misses for data and code

Video

Slides

The following slides have been made available for this session:

Speaker

Thomas Munro