> On Jul 22, 2024, at 7:00 AM, Holger Jakobs <holger@xxxxxxxxxx> wrote: > > Typically, queries which need a lot of memory (RAM) create temp files if work_mem isn't sufficient for some sorting or hash algorithms. > > Increasing work_mem will help, but small temp files don't create any trouble. > > You can set work_mem within each session, don't set it high globally. I understand those things--my question is why, with work_mem set to 128MB, I would see tiny temp files (7452 is common, as is 102, and I've seen as small as 51).
