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

Bruce Momjian <pgman@candle.pha.pa.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