Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 518E9632CE0;
	Wed, 20 Jan 2010 01:21:24 -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 17796-05; Wed, 20 Jan 2010 05:21:12 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9])
	by mail.postgresql.org (Postfix) with ESMTP id 268E663225B;
	Wed, 20 Jan 2010 01:21:13 -0400 (AST)
Received: from [192.168.1.3] (pool-96-244-14-10.bltmmd.fios.verizon.net
	[96.244.14.10])
	by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis)
	id 0LjM2Z-1O7MaJ2pBf-00d1ev; Wed, 20 Jan 2010 06:21:10 +0100
Message-ID: <4B5692C3.6080807@2ndquadrant.com>
Date: Wed, 20 Jan 2010 00:21:07 -0500
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Greg Stark <gsstark@mit.edu>
CC: Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org,
	pgsql-performance@postgresql.org,
	Michael Clemmons <glassresistor@gmail.com>,
	Hannu Krosing <hannu@2ndquadrant.com>,
	Scott Marlowe <scott.marlowe@gmail.com>
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1
	ubuntu karmic 	slow createdb)
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<200912282354.51892.andres@anarazel.de>
	<200912282359.43979.andres@anarazel.de>
	<200912291930.50812.andres@anarazel.de>
	<407d949e1001180835m79ffe3e4w53e20ce2e1a58f2d@mail.gmail.com>
	<407d949e1001190652i43f4f276x6a485f375647219a@mail.gmail.com>
	<407d949e1001190657m7cd289d5s74c3d8c475e0bdc7@mail.gmail.com>
In-Reply-To: <407d949e1001190657m7cd289d5s74c3d8c475e0bdc7@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------090505030809010709010004"
X-Provags-ID: V01U2FsdGVkX1+Y0WkKDKqmZ9bcEAnmFtwLamod9SG82TLHOMd
	KgcpVSTI6FrsDpUWkTbA7A04TS78ebxE/aks8w36pNog5ulf+B
	H7XTGRoukkNpu7s9bmlhjgKIXgbNeGB
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.428 tagged_above=-10 required=5 tests=AWL=0.170,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/418
X-Sequence-Number: 37298

This is a multi-part message in MIME format.
--------------090505030809010709010004
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greg Stark wrote:
> On Tue, Jan 19, 2010 at 2:52 PM, Greg Stark <gsstark@mit.edu> wrote:
>   
>> Barring any objections shall I commit it like this?
>>     
>
> Actually before we get there could someone who demonstrated the
> speedup verify that this patch still gets that same speedup?
>   

I think the final version of this patch could use at least one more 
performance checking report that it does something useful.  We got a lot 
of data from Andres, but do we know that the improvements here hold for 
others too?  I can take a look at it later this week, I have some 
interest in this area.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com


--------------090505030809010709010004
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Greg Stark wrote:
<blockquote
 cite="mid:407d949e1001190657m7cd289d5s74c3d8c475e0bdc7@mail.gmail.com"
 type="cite">
  <pre wrap="">On Tue, Jan 19, 2010 at 2:52 PM, Greg Stark <a class="moz-txt-link-rfc2396E" href="mailto:gsstark@mit.edu">&lt;gsstark@mit.edu&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Barring any objections shall I commit it like this?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Actually before we get there could someone who demonstrated the
speedup verify that this patch still gets that same speedup?
  </pre>
</blockquote>
<br>
I think the final version of this patch could use at least one more
performance checking report that it does something useful.&nbsp; We got a
lot of data from Andres, but do we know that the improvements here hold
for others too?&nbsp; I can take a look at it later this week, I have some
interest in this area.<br>
<br>
<pre class="moz-signature" cols="72">-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
<a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a>  <a class="moz-txt-link-abbreviated" href="http://www.2ndQuadrant.com">www.2ndQuadrant.com</a>
</pre>
</body>
</html>

--------------090505030809010709010004--