Hi,

Le lun. 12 juil. 2021 à 14:13, MichaelDBA <michael...@sqlexec.com> a écrit :

> hmmm, I think spilling over to disk for temporary tables is handled by
> an entirely different branch in the PG source code.  In fact, some other
> folks have chimed in and said log_temp_files doesn't relate to temp
> files at all use by temporary tables, just queries as you mentioned
> below elsewhere.  This seems to be a dark area of PG that is not
> convered well.
>

As far as I know, log_temp_files only relates to sort/hash going to disks,
not to temporary objects (tables and indexes).

But, even if they are, they are definitely distinguishable by name.
Sort/hash temp files are located in pgsql_tmp, and have a specific template
name. Temp files for temporary objects are located in the database
subdirectory, and also have a specific template name, different from the
sort/hash temp files' one.

Regards.

Reply via email to