Am 22.07.24 um 14:50 schrieb Scott Ribe:
> What would be the cause of small temp files? For example:
>
> temporary file: path "base/pgsql_tmp/pgsql_tmp1261242.83979", size 7452
>
> work_mem is set to 128MB
>
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
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.
Regards,
Holger
>
>
--
Holger Jakobs, Bergisch Gladbach