Re: unlogged tables

Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Dec 7, 2010 at 3:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think a more relevant question is how complicated it'll be to issue
>> those fsyncs --- do you have a concrete implementation in mind?

> It can reuse most of the infrastructure we use for re-initializing
> everything after a crash or unclean shutdown.  We just iterate over
> every tablepace/dbspace directory and look for files with _init forks.
>  If we find any then we open the main fork files and fsync() each one.

I assume you meant "all the other fork files", but OK.  Still, couldn't
that be rather expensive in a large DB?
        regards, tom lane