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

On 6/5/23 11:54, Adrien Nayrat wrote:
> Hello,
> 
> 
> I am experiencing the same issue on an up-to-date Postgres (13.11).
> I have many files corresponding to temporary tables (for example 
> t7_4191281453.90). These files are not cleaned until we manually restart 
> Postgres (all client session are closed).
> 
> When temporary table were created, we reached disk full (Disk quota 
> exceeded). Then the instance crashed and restarted in recovery mode. But 
> files related to temporary tables still exist.
> 
> It seems there is something missing to clean these files after a recovery ?
> 
> Regards,
> 

Replying to myself when reading this item in PG 14 release notes:

Remove temporary files after backend crashes (Euler Taveira)

Previously, such files were retained for debugging purposes. If 
necessary, deletion can be disabled with the new server parameter 
remove_temp_files_after_crash.


I understand, it is expected to keep these files for debugging purpose 
after a recovery. And since 14, we can ask Postgres to clean them thanks 
to remove_temp_files_after_crash