Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 56462632EB4 for ; Fri, 11 Dec 2009 16:44:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 96242-05 for ; Fri, 11 Dec 2009 20:44:17 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25]) by mail.postgresql.org (Postfix) with ESMTP id 02A06632CD3 for ; Fri, 11 Dec 2009 16:44:20 -0400 (AST) Received: by ey-out-2122.google.com with SMTP id 22so343697eye.33 for ; Fri, 11 Dec 2009 12:44:19 -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 :from:date:message-id:subject:to:cc:content-type; bh=KP+MKg3kofpT3mxMCNTp22sKTOh0hHyl3QZoaLyhZzU=; b=s9Ww1eMUUV9mphyVtx7dhs1Jq+2epgjP4UoVwVcA4pRtTukDyfptWXPcSkr36dsdZt 8MflWckW/dM+p7dB8crhiD4rRChpNVgcuANgrL0VxpRPThhcTJkrFZC3gdCxXeVjMqCm HU7MdngQ2vCuZYHxRUPJaZHZYoOWcGAG7YBAE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=FXc6tHOqN2TYnmYvU4YP1jJD5BTt7TgFaocAqCqkEzaJ2kgYe9G9J/3h7dMUW3w/rY M26fqJkmozTUaoUxa/8ajYdYJTjAk15QGRgnd0GA6C9MI5dycoEugjq7dRwMMGCQuovg R5e4no/ibq6Td7qn3ifTlW6jQnb1y/86MmmfE= MIME-Version: 1.0 Received: by 10.216.90.203 with SMTP id e53mr733377wef.86.1260564259252; Fri, 11 Dec 2009 12:44:19 -0800 (PST) In-Reply-To: <1260554319.2611.10.camel@jd-desktop.unknown.charter.com> References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <200912102256.59868.andres@anarazel.de> <4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com> <200912102309.04057.andres@anarazel.de> <1260554319.2611.10.camel@jd-desktop.unknown.charter.com> From: Nikolas Everett Date: Fri, 11 Dec 2009 15:43:59 -0500 Message-ID: Subject: Re: 8.4.1 ubuntu karmic slow createdb To: jd@commandprompt.com Cc: Andres Freund , pgsql-performance@postgresql.org, Michael Clemmons Content-Type: multipart/alternative; boundary=0016e6d7e32de3adca047a79fcef X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200912/152 X-Sequence-Number: 36766 --0016e6d7e32de3adca047a79fcef Content-Type: text/plain; charset=ISO-8859-1 Turning fsync off on a dev database is a bad idea? Sure you might kill it and have to start over, but thats kind of the point in a dev database. On Fri, Dec 11, 2009 at 12:58 PM, Joshua D. Drake wrote: > On Thu, 2009-12-10 at 20:38 -0500, Nikolas Everett wrote: > > In my limited experience ext4 as presented by Karmic is not db > > friendly. I had to carve my swap partition into a swap partition and > > an xfs partition to get better db performance. Try fsync=off first, > > but if that doesn't work then try a mini xfs. > > Do not turn fsync off. That is bad advice. I would not suggest ext4 at > this point for database operations. Use ext3. It is backward compatible. > > Joshua D. Drake > > > -- > PostgreSQL.org Major Contributor > Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 > Consulting, Training, Support, Custom Development, Engineering > If the world pushes look it in the eye and GRR. Then push back harder. - > Salamander > > --0016e6d7e32de3adca047a79fcef Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Turning fsync off on a dev database is a bad idea?=A0 Sure you might kill i= t and have to start over, but thats kind of the point in a dev database.
On Fri, Dec 11, 2009 at 12:58 PM, Joshua D.= Drake <jd@com= mandprompt.com> wrote:
On Thu, 2009-12-10 at 20:38 -0500, Nikolas Everett wrote:
> In my limited experience ext4 as presented by Karmic is not db
> friendly. =A0I had to carve my swap partition into a swap partition an= d
> an xfs partition to get better db performance. =A0Try fsync=3Doff firs= t,
> but if that doesn't work then try a mini xfs.

Do not turn fsync off. That is bad advice. I would not suggest ext4 a= t
this point for database operations. Use ext3. It is backward compatible.
Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Sa= lamander


--0016e6d7e32de3adca047a79fcef--