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

From: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
To: manojkumar(at)ameyo(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16739: Temporary files not deleting from data folder on disk
Date: 2023-06-05 09:54:27
Message-ID: 4b522839-532b-d5f9-1a38-8f72ef1bfae2@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Adrien Nayrat 2023-06-05 09:59:04 Re: BUG #16739: Temporary files not deleting from data folder on disk
Previous Message Alexander Lakhin 2023-06-05 09:00:01 Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple