Re: vacuumlo
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: vacuumlo |
| Дата | |
| Msg-id | CAECtzeXEiLu1j2UXPFnZmU3sVKuGH5eWb9Z5MxhhB+Stq-AmxQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: vacuumlo (Atul Kumar <akumar14871@gmail.com>) |
| Ответы |
RE: vacuumlo
|
| Список | pgsql-admin |
Le jeu. 2 sept. 2021 à 07:11, Atul Kumar <akumar14871@gmail.com> a écrit :
Hi,Don’t you think it as a drawback of postgres that such temporary files don’t get deleted automatically once the transaction gets committed or rolled back .
They are automatically removed in case of a proper commit or rollback. They aren't in case of a crash.
Could you suggest a good permanent solution for such case.
You should try https://github.com/bdrouvot/pg_orphaned to find the list of orphaned files. It does a pretty good job at it.
--
Guillaume.
В списке pgsql-admin по дате отправления: