Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Date
Msg-id 22649.1266169035@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)  (Andres Freund <andres@anarazel.de>)
Responses Re: Re: Faster CREATE DATABASE by delaying fsync  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On Sunday 14 February 2010 18:11:39 Tom Lane wrote:
>> It seems to me that we're talking about a huge hit in both code
>> complexity and performance to deal with a problem that doesn't actually
>> occur in the field; and which furthermore is trivially solved on any
>> modern filesystem by choosing the right filesystem options.  Why don't
>> we just document those options, instead?

> Which options would that be? I am not aware that there any for any of the 
> recent linux filesystems.

Shouldn't journaling of metadata be sufficient?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Federico Di Gregorio
Date:
Subject: Re: psycopg2 license changed
Next
From: Simon Riggs
Date:
Subject: Re: Optimizing GetConflictingVirtualXIDs()