Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id AD722632F66;
	Mon,  8 Feb 2010 00:53:56 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024)
	with ESMTP id 68372-03; Mon,  8 Feb 2010 04:53:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f214.google.com (mail-fx0-f214.google.com
	[209.85.220.214])
	by mail.postgresql.org (Postfix) with ESMTP id CAB6B6328CE;
	Mon,  8 Feb 2010 00:53:24 -0400 (AST)
Received: by fxm6 with SMTP id 6so4854757fxm.18
	for <multiple recipients>; Sun, 07 Feb 2010 20:53:23 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=TbIUs6TdXuEkpdhGtYrdUKFCCL4R5GWkyPJIHByO8Xc=;
	b=tOio2hbbpUgXcx8E6k24Xii2ThT0kJzVJdnNJqtqJrazaWgfjuIaaN+uy1UumJtSgZ
	ZO0nDhCOJXk3WfB2dRkhYPYerTcLtadz7c07BZTiLqXtSjZ4j6nUOQkHX0i7KpqaWIvx
	3p/PMTBLRQ2sN0Sh+GCf6O1wI1Qt4nI1kpc3s=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=GNk9OUTqajDVKnh4O9kYP7/Q5Wp7xHOBWXWLr3bXui2IE/88aKrDjjR7ehTQ4qkWrg
	eOmo4v05DliRsKstJNEZp5nr8dFfiteLCko5hXcpBO4XDRW5dNz9RUuPqIV2HXH4MEAQ
	aml2i1QFXNaJM8u/wX8uX3aOMzHIVLMtR+Bkw=
MIME-Version: 1.0
Received: by 10.239.187.132 with SMTP id l4mr568317hbh.87.1265604803526; Sun,
	07 Feb 2010 20:53:23 -0800 (PST)
In-Reply-To: <20100208030901.GA7407@alvh.no-ip.org>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<603c8f071002071023v6d5329at6f80b453f472ebb3@mail.gmail.com>
	<201002071927.27795.andres@anarazel.de>
	<201002080231.47206.andres@anarazel.de>
	<20100208030901.GA7407@alvh.no-ip.org>
Date: Sun, 7 Feb 2010 23:53:23 -0500
Message-ID: <603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1
	ubuntu karmic slow createdb)
From: Robert Haas <robertmhaas@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org,
	Tom Lane <tgl@sss.pgh.pa.us>, Greg Smith <greg@2ndquadrant.com>,
	Greg Stark <gsstark@mit.edu>, pgsql-performance@postgresql.org,
	Michael Clemmons <glassresistor@gmail.com>,
	Hannu Krosing <hannu@2ndquadrant.com>,
	Scott Marlowe <scott.marlowe@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.264 tagged_above=-10 required=5 tests=AWL=-1.079,
	BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201002/115
X-Sequence-Number: 37536

On Sun, Feb 7, 2010 at 10:09 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Andres Freund escribi=F3:
>> I personally think the fsync on the directory should be added to the sta=
ble
>> branches - other opinions?
>> If wanted I can prepare patches for that.
>
> Yeah, it seems there are two patches here -- one is the addition of
> fsync_fname() and the other is the fsync_prepare stuff.

Andres, you want to take a crack at splitting this up?

...Robert