Re: BUG #16739: Temporary files not deleting from data folder on disk

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Maxim Boguk <maxim.boguk@gmail.com>
Cc: Manoj Kumar <manojkumar@ameyo.com>, pgsql-bugs@lists.postgresql.org
Date: 2020-11-24T18:59:02Z
Lists: pgsql-bugs
Maxim Boguk <maxim.boguk@gmail.com> writes:
> It seems that these temp files are the result of normal query execution
> (and will be cleared when query finishes).
> Have you tried enabling log_temp_files and check what query generates these
> temp files?

Judging by the file names, these are temp tables (created by CREATE TEMP
TABLE or the like), not temp files generated during query execution.
The latter would have names beginning in "pgsql_tmp", if I read the
code correctly.

			regards, tom lane