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

Поиск
Список
Период
Сортировка
От Adrien Nayrat
Тема Re: BUG #16739: Temporary files not deleting from data folder on disk
Дата
Msg-id 4b522839-532b-d5f9-1a38-8f72ef1bfae2@anayrat.info
обсуждение исходный текст
Ответ на BUG #16739: Temporary files not deleting from data folder on disk  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16739: Temporary files not deleting from data folder on disk  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Список 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





В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alexander Lakhin
Дата:
Сообщение: Re: BUG #17959: amcheck fails to find a matching index tuple for an invisible heap tuple
Следующее
От: Adrien Nayrat
Дата:
Сообщение: Re: BUG #16739: Temporary files not deleting from data folder on disk