Re: unlogged tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: unlogged tables
Date
Msg-id 29798.1291761094@sss.pgh.pa.us
Whole thread Raw
In response to Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: unlogged tables  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Final(?) proposal for wal_sync_method changes
Next
From: Josh Berkus
Date:
Subject: Re: Final(?) proposal for wal_sync_method changes