Skip to content

Glossary: PostgreSQL Beyond the Basics

Spill to disk

Also written: spilled, temporary files

What a sort or hash step does when it needs more than `work_mem`: it writes temporary files to disk, shown as `external merge Disk:` or a `Hash` with more than one batch.

Where the book teaches it

Related terms

work_memSort Method (quicksort, external merge)