Conference Schedule - PGCon 2020

work_mem warriors: Teaching HashAgg, HashJoin, and Other Memory-Intensive Operators to Respect work_mem's Boundaries

Date: 2020-05-27
Time: 14:00 - 14:45
Room: Stream 1
Level: Intermediate
Feedback: Leave feedback

This talk appears on stream1

Recent work on the Postgres executor has made improvements to memory management -- from accounting for the memory used to responding to memory pressure. It is important to bind the memory usage of the database with the appropriate execution mechanisms and to choose those during planning based on cost in order to meet users' expectations and ensure predictable performance.

This talk will cover three such improvements: the addition of memory accounting information to MemoryContexts, the memory-bounding of HashAgg (spilling HashAgg to disk), and the adaptive hashjoin fallback to nested hashloop join.

The talk will also include an interactive session to solicit feedback from users on their expectations and experiences with work_mem and the memory behavior of Postgres.

Slides

The following slides have been made available for this session:

Speaker

Jeff Davis
Melanie Plageman