db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Sort spill

A sort that does not fit in work_mem spills to disk and slows down. EXPLAIN (ANALYZE) shows it as "Sort Method: external merge".

task

work_mem is 64kB, so sorting 20 devices of readings spills to disk. Raise work_mem until the Sort stays in memory.

hints