Markus Schaber <[EMAIL PROTECTED]> writes: > As I said the leftovers are likely to be caused by hard kills and > backend crashes, so I would not go into deeper analysis, but maybe the > finding and possibly removing of such leftovers should be half-automated > to assist server admins.
It's been discussed. Personally I'm afraid of the idea of automatically deleting files that seem unreferenced, but having a tool to find them for manual deletion isn't a bad idea. I think Bruce had a prototype patch at one point --- not sure what the status is. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings