Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D809863416A;
	Sun,  7 Feb 2010 23:15: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 50552-07; Mon,  8 Feb 2010 03:15:25 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 1CCFF6343BA;
	Sun,  7 Feb 2010 23:09:07 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id 4976A348037;
	Sun,  7 Feb 2010 19:09:04 -0800 (PST)
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id j92fW+DQwI-D; Sun,  7 Feb 2010 19:09:04 -0800 (PST)
Received: from perhan.alvh.no-ip.org (190-95-31-230.bk17-dsl.surnet.cl
	[190.95.31.230])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id DE207348036;
	Sun,  7 Feb 2010 19:09:03 -0800 (PST)
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 486286E810; Mon,  8 Feb 2010 00:09:01 -0300 (CLST)
Date: Mon, 8 Feb 2010 00:09:01 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org, Robert Haas <robertmhaas@gmail.com>,
	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>
Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was
	8.4.1 ubuntu karmic slow createdb)
Message-ID: <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>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <201002080231.47206.andres@anarazel.de>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.797 tagged_above=-10 required=5 tests=AWL=-0.687,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201002/114
X-Sequence-Number: 37535

Andres Freund escribió:

> 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.

Yeah, it seems there are two patches here -- one is the addition of
fsync_fname() and the other is the fsync_prepare stuff.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.