Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A60EE632A5D for ; Sun, 14 Feb 2010 19:34:26 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56072-06 for ; Sun, 14 Feb 2010 23:34:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id 1A886632716 for ; Sun, 14 Feb 2010 19:34:15 -0400 (AST) Received: by pwj8 with SMTP id 8so421801pwj.19 for ; Sun, 14 Feb 2010 15:34:14 -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:content-transfer-encoding; bh=jwnOHrXDBtDGKnrdjtIKgd0/eomEagJKIwjkKvXoNkQ=; b=rXGrOmFdbhLW6LLNgkeWDc997buylBI0Y9Y7/8UoBzLhMOhM2brBAEU+Eph/UBN8EU KEjDtqfK5ce95rt2mYRrlOWeyanTTGHNB6JwsLMXcpIi9bjGUOl8AT73psx7wyGYDd+0 4zn09HSdQNB8SJhAtFsMWyU29ATfrdeDGk91E= 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 :content-transfer-encoding; b=dYEfmMwdCDfPzwQgCC3BVxG7Zjs5/nFT1Rro+qdzzgF5jikhAQrCJDPbTWC8uxg0bO AML5Tgywl6CHCuWkIKLnPTHGwqm0wrL2xMZxWIn/tOkeNU54uU7CPd73Lll4cJvlJ7hb NH8GzYtZVWwBNvvuHQcEEiw43V58gXX5oOSyY= MIME-Version: 1.0 Received: by 10.140.55.5 with SMTP id d5mr2570040rva.243.1266190454153; Sun, 14 Feb 2010 15:34:14 -0800 (PST) In-Reply-To: <603c8f071002141257g2dfb7a09i5c5930e9787783e1@mail.gmail.com> References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <20100208030901.GA7407@alvh.no-ip.org> <603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com> <201002110327.35810.andres@anarazel.de> <603c8f071002120749o6a2e9e54h5cf21dc91d1790b9@mail.gmail.com> <407d949e1002140603v1c7515d7t697568a3865ac6fe@mail.gmail.com> <407d949e1002140731j85a4f97nc053ec1b0f3cc458@mail.gmail.com> <603c8f071002141257g2dfb7a09i5c5930e9787783e1@mail.gmail.com> From: Greg Stark Date: Sun, 14 Feb 2010 23:33:54 +0000 X-Google-Sender-Auth: e86be39d1b0318f7 Message-ID: <407d949e1002141533m406d6ffev383908177ff5a18a@mail.gmail.com> Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) To: Robert Haas Cc: Andres Freund , pgsql-hackers@postgresql.org 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.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/1166 X-Sequence-Number: 157509 On Sun, Feb 14, 2010 at 8:57 PM, Robert Haas wrote: > On a pragmatic note, if this does turn out to be a problem, it's a > bug: and we can and do fix bugs whenever we discover them. =A0But the > other part of this patch - to speed up createdb - is a feature - and > we are very rapidly running out of time for 9.0 features. =A0So I'd like > to vote for getting the feature part of this committed (assuming it's > in good shape, of course) and we can continue to investigate the other > issues but without quite as much urgency. No problem, I already committed the part that overlaps so I can commit the rest now. I just want to take extra care given how much wine I've already had tonight... Incidentally, sorry Andres, I forgot to credit you in the first commit. --=20 greg