Re: Patch to remove sort files, temp tables, unreferenced files - Mailing list pgsql-patches

From Tom Lane
Subject Re: Patch to remove sort files, temp tables, unreferenced files
Date
Msg-id 9253.991269151@sss.pgh.pa.us
Whole thread Raw
In response to Re: Patch to remove sort files, temp tables, unreferenced files  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Patch to remove sort files, temp tables, unreferenced files  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Patch to remove sort files, temp tables, unreferenced files  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch to remove sort files, temp tables, unreferenced files
Next
From: Bruce Momjian
Date:
Subject: Re: Patch to remove sort files, temp tables, unreferenced files