Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D05E6632515 for ; Fri, 11 Dec 2009 19:59:23 -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 62269-02 for ; Fri, 11 Dec 2009 23:59:16 +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.26]) by mail.postgresql.org (Postfix) with ESMTP id 15566632200 for ; Fri, 11 Dec 2009 19:59:15 -0400 (AST) Received: by ey-out-2122.google.com with SMTP id 22so374428eye.33 for ; Fri, 11 Dec 2009 15:59:14 -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=fFdTxLIEXq2/4H6NPRtsic4H/EB+1Yvl+WVvkaHG2qg=; b=Zm79hy1Mg12vLtOm72wHFyz8gkRsuuCpaO0ptJnsoS5zUogPpIOVgJzn17CrbGiuew BFUq7jlpBuOh3yxNpJNoDASskj2YfAO2nlVuymW1BdFkeZaOa31VTGHNPCcxXD3Eg+9Y uWJhoriWUtjjr0kmsxLm0vEngQeMWyfG8DWXk= 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=ImQokzBn5RraaeMEr/ydN2Zgd8tJy27AM3LwljbeFSrHKBoagV1UJwcUhzvp569HRc jYiMHoBgz0kZ6El6T/LxghTlLYkONlIgDlIdmppXKRjW1ixGg3AEs9YbzcnW7qXekP3z A6bgfKAI/CrH5mfF3VzYYYOXulIkQ/uTN/z/w= MIME-Version: 1.0 Received: by 10.216.85.130 with SMTP id u2mr844702wee.135.1260575953894; Fri, 11 Dec 2009 15:59:13 -0800 (PST) In-Reply-To: <4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com> References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <200912102309.04057.andres@anarazel.de> <1260554319.2611.10.camel@jd-desktop.unknown.charter.com> <1260564610.2611.41.camel@jd-desktop.unknown.charter.com> <4B22CA3A.1040909@2ndquadrant.com> <4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com> Date: Fri, 11 Dec 2009 16:59:13 -0700 Message-ID: Subject: Re: 8.4.1 ubuntu karmic slow createdb From: Scott Marlowe To: Michael Clemmons Cc: pgsql-performance@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: 200912/162 X-Sequence-Number: 36776 On Fri, Dec 11, 2009 at 3:52 PM, Michael Clemmons wrote: > Thanks all this has been a good help. > I don't have control(or easy control) over unit tests creating/deleting > databases since Im using the django framework for this job. Reminds of the issues we had with Ruby on Rails and it's (at the time) very mysql-centric tools that made us take a fork to large portions of its brain to get things like this working. Worked with a developer for a day or two fixing most of the worst mysqlisms in RoR at the time to just get this kind of stuff working. >=A0 Createdb takes > 12secs on my system(9.10 pg8.4 and ext4)=A0 which is impossibly slow for > running 200unittests. Wait, so each unit test createdbs by itself? Wow... >=A0 Fsync got it to .2secs or so which is blazing but > also the speed I expected being used to 8.3 and xfs.=A0 This dev box is m= y > laptop and the data is litterally unimportant and doesn't exist longer th= an > 20sec but Im all about good practices.=A0 Will definately try synchronous > commit tonight once Im done working for the day.=A0 I've got some massive > copying todo later though so this will probably help in the future as wel= l. Yeah, I'd probably resort to fsync off in that circumstance too especially if syn commit off didn't help that much.