Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1EC69633C7D for ; Fri, 12 Feb 2010 11:49:33 -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 50777-03-4 for ; Fri, 12 Feb 2010 15:48:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f212.google.com (mail-bw0-f212.google.com [209.85.218.212]) by mail.postgresql.org (Postfix) with ESMTP id 73C78633987 for ; Fri, 12 Feb 2010 11:49:19 -0400 (AST) Received: by bwz4 with SMTP id 4so2187877bwz.22 for ; Fri, 12 Feb 2010 07:49:17 -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=/d1GqOj6uCD4zuhJZJdQ+peCxVLZPeXP82x5hx3vq5w=; b=lhImGrkfr/bwlV9AIFYuY46jmQT/BVbEaGaQ8VC+T4qhF80996zg428JIRR+V3yNtp KMh3fJotNnD8AlwyLHrp7D4PGe9pf0muuLya9b4105rM/5QmpYwU4vlLpy1E63cffy4c 9hMSP0sdYM7xyxcM2mjM2RTCVP7O2HRalYbyc= 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=ZrIvTqBiQ6CFhPoz72oYzCbKp3ROE98wn1xOazWviqmxIYgnMoL8LFcueNm1yobc9O vByeD9ox9qzVlWtdxVLHf4E9Pm0KvWzTkPs8ll1Rby1J/r1yEaVNpTqr699K++MxjA5K CNFpRITsgSA9n0ZNFZtgg1gHlFdYZ5bkAWZAs= MIME-Version: 1.0 Received: by 10.239.189.140 with SMTP id t12mr159407hbh.146.1265989757013; Fri, 12 Feb 2010 07:49:17 -0800 (PST) In-Reply-To: <201002110327.35810.andres@anarazel.de> References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <20100208030901.GA7407@alvh.no-ip.org> <603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com> <201002110327.35810.andres@anarazel.de> Date: Fri, 12 Feb 2010 10:49:16 -0500 Message-ID: <603c8f071002120749o6a2e9e54h5cf21dc91d1790b9@mail.gmail.com> Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) From: Robert Haas To: Andres Freund Cc: pgsql-hackers@postgresql.org, Greg Stark 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=-2.476 tagged_above=-10 required=5 tests=AWL=0.123, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/1023 X-Sequence-Number: 157366 On Wed, Feb 10, 2010 at 9:27 PM, Andres Freund wrote: > On Monday 08 February 2010 05:53:23 Robert Haas wrote: >> On Sun, Feb 7, 2010 at 10:09 PM, Alvaro Herrera >> >> 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. >> > >> > 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? > I hope I didnt duplicate Gregs work, but I didnt hear back from him, so..= . > > Everything <8.1 is hopeless because cp is used there... I didnt see it wo= rth > to replace that. The patch applies cleanly for 8.1 to 8.4 and survives th= e > regression tests > > Given pg's heavy commit model I didnt see a point to split the patch for = 9.0 > as well... I'd probably argue for committing this patch to both HEAD and the back-branches, and doing a second commit with the remaining stuff for HEAD only, but I don't care very much. Greg Stark, have you managed to get your access issues sorted out? If you like, I can do the actual commit on this one. ...Robert