Glossary: PostgreSQL Beyond the Basics
work_mem
The memory each sort or hash step may use before spilling to temporary files (4 MB by default). Raise it per transaction with `SET LOCAL`, not for the whole server.
Where the book teaches it
Related terms
SET LOCALSort Method (quicksort, external merge)Spill to disk