Re: small temp files

[Holger Jakobs <holger@xxxxxxxxxx>]

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@xxxxxxxxxxxxxxxx
> 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

Attachment: OpenPGP_signature
Description: OpenPGP digital signature