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

Adrien Nayrat <adrien.nayrat@anayrat.info>

From: Adrien Nayrat <adrien.nayrat@anayrat.info>
To: manojkumar@ameyo.com, pgsql-bugs@lists.postgresql.org
Date: 2023-06-05T09:54:27Z
Lists: pgsql-bugs
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,

-- 
Adrien NAYRAT