Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 4973A632287;
	Mon,  8 Feb 2010 03:14:17 -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 94006-07; Mon,  8 Feb 2010 07:13:44 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40])
	by mail.postgresql.org (Postfix) with ESMTP id 2FB63632268;
	Mon,  8 Feb 2010 03:14:04 -0400 (AST)
Received: from alap2.localnet (e178233004.adsl.alicedsl.de [85.178.233.4])
	by mail.anarazel.de (Postfix) with ESMTPSA id 572A2448004;
	Mon,  8 Feb 2010 08:14:00 +0100 (CET)
From: Andres Freund <andres@anarazel.de>
To: Robert Haas <robertmhaas@gmail.com>
Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1
	ubuntu karmic slow createdb)
Date: Mon, 8 Feb 2010 08:13:41 +0100
User-Agent: KMail/1.13.0 (Linux/2.6.33-rc5-andres-00243-g6ea299e; KDE/4.3.98;
	x86_64; ; )
Cc: Alvaro Herrera <alvherre@commandprompt.com>, 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>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<20100208030901.GA7407@alvh.no-ip.org>
	<603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
In-Reply-To: <603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <201002080813.51977.andres@anarazel.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.045 tagged_above=-10 required=5 tests=AWL=-1.046,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 201002/116
X-Sequence-Number: 37537

On Monday 08 February 2010 05:53:23 Robert Haas wrote:
> On Sun, Feb 7, 2010 at 10:09 PM, Alvaro Herrera
>=20
> <alvherre@commandprompt.com> wrote:
> > Andres Freund escribi=F3:
> >> I personally think the fsync on the directory should be added to the
> >> stable branches - other opinions?
> >> If wanted I can prepare patches for that.
> >=20
> > Yeah, it seems there are two patches here -- one is the addition of
> > fsync_fname() and the other is the fsync_prepare stuff.
>=20
> Andres, you want to take a crack at splitting this up?
Will do. Later today or tomorrow morning.

Andres