Re: Patch to remove sort files, temp tables, unreferenced files

OK, seems I am the only one that is concerned about orphaned files, so,
Tom, would you let me know which parts of the patch you want applied or
apply the parts you want yourself. Thanks.

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> I don't. The intention (not yet implemented, but Vadim's referred to it
> >> repeatedly) is that relation file creation/deletion will be logged in
> >> WAL, and so it can be redone or undone after a crash. That seems a much
> >> more secure approach than anything you've proposed in this thread.
>
> > I prefer a WAL cleanup myself, especially if it can be done for 7.2, but
> > how do we do that without fsync'ing the WAL every time we create a file?
>
> Yes, we'd need to fsync WAL at the file creation/deletion points. So?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026