Hi,
Le lun. 12 juil. 2021 à 14:13, MichaelDBA <MichaelDBA@xxxxxxxxxxx> 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.
