Bruce Momjian wrote:
Tom Lane wrote:Now that I think about it, I believe Bruce recently removed this on my advice; I was thinking that the problem shouldn't occur anymore now that
True.
we WAL-log file creation and deletion. But actually the present form of the WAL entries doesn't ensure that a file created by a transaction that crashes before committing will go away, because file deletion actions are only logged (and replayed) at transaction commit/abort. So it probably should go back in. Or else we could add more WAL logging
Wording updated to:
* Remove unreferenced table files created by a transactions that were in-progress when the server crashed
I don't think is a good idea put the words: "when the server crashed" in a TODO list, may be is better write: "when the server is killed abruptly".
My 2 cents.
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
