Re: vacuumlo - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: vacuumlo
Date
Msg-id CAECtzeXEiLu1j2UXPFnZmU3sVKuGH5eWb9Z5MxhhB+Stq-AmxQ@mail.gmail.com
Whole thread Raw
In response to Re: vacuumlo  (Atul Kumar <akumar14871@gmail.com>)
Responses RE: vacuumlo  (Ian Dauncey <Ian.Dauncey@bankzero.co.za>)
List 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 by date:

Previous
From: Shaish Guni
Date:
Subject: Re: vacuumlo
Next
From: Kevin Burke
Date:
Subject: "README" mentions "INSTALL" but this file doesn't exist in git checkout