Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0AAA1633ADB;
	Mon,  8 Feb 2010 14:36:21 -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 42633-04; Mon,  8 Feb 2010 18:35:42 +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-pz0-f180.google.com (mail-pz0-f180.google.com
	[209.85.222.180])
	by mail.postgresql.org (Postfix) with ESMTP id 0BCCC633524;
	Mon,  8 Feb 2010 14:36:05 -0400 (AST)
Received: by pzk10 with SMTP id 10so2109956pzk.19
	for <multiple recipients>; Mon, 08 Feb 2010 10:36:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:in-reply-to
	:references:from:date:x-google-sender-auth:message-id:subject:to:cc
	:content-type; bh=IgOoTye9gN8jLTNlbC6Ek4it7l7e/A2VQuZP2HLKq5g=;
	b=jOvWcc5e/a015PQjergbgZEJFkZamgaphPF8uilGxf+Pz4soG/6/m5e+b8zZhYWGeR
	i769JUMoaA+4peT0gEUJkCgonrY7P+GI7YvKPLGSXiuJsGfg7IJb9GXsGB15Fccm6ZP9
	YkDAaEHrOKKh9vTLl+Yuq/poLQnGr8TQzhO5E=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:from:date
	:x-google-sender-auth:message-id:subject:to:cc:content-type;
	b=wBDkA8pMXHDNf+SYh1MkIe5ZBH6lYGfgUd5KdKNGzwi/pAawategk28mOOEKNUHcYH
	gc3bL+6w1oKE8nTYUoClZTlIgHid+qN/L9EEUfk/Euof+1grlwbLo3OpyecMMFOgw1hv
	FxxueXQll0b09ar7xDUlGo/qN9DfFUVB9yIkg=
MIME-Version: 1.0
Received: by 10.141.106.10 with SMTP id i10mr4743333rvm.267.1265654164703;
	Mon, 08 Feb 2010 10:36:04 -0800 (PST)
In-Reply-To: <603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
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>
	<603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
From: Greg Stark <gsstark@mit.edu>
Date: Mon, 8 Feb 2010 18:34:01 +0000
X-Google-Sender-Auth: 9cc35d5a2af414a7
Message-ID: <407d949e1002081034n3dd82addw2b93d35db042042c@mail.gmail.com>
Subject: Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1
	ubuntu karmic slow createdb)
To: Robert Haas <robertmhaas@gmail.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>,
	Andres Freund <andres@anarazel.de>,
	pgsql-hackers@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>,
	Greg Smith <greg@2ndquadrant.com>, 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
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.498 tagged_above=-10 required=5 tests=AWL=0.101,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/123
X-Sequence-Number: 37544

On Mon, Feb 8, 2010 at 4:53 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sun, Feb 7, 2010 at 10:09 PM, Alvaro Herrera
>> Yeah, it seems there are two patches here -- one is the addition of
>> fsync_fname() and the other is the fsync_prepare stuff.

Sorry, I'm just catching up on my mail from FOSDEM this past weekend.

I had come to the same conclusion as Greg that I might as well just
commit it with Tom's "pg_flush_data()" name and we can decide later if
and when we have pg_fsync_start()/pg_fsync_finish() whether it's worth
keeping two apis or not.

So I was just going to commit it like that but I discovered last week
that I don't have cvs write access set up yet. I'll commit it as soon
as I generate a new ssh key and Dave installs it, etc. I intentionally
picked a small simple patch that nobody was waiting on because I knew
there was a risk of delays like this and the paperwork. I'm nearly
there.

-- 
greg