Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6F444632488 for ; Thu, 10 Dec 2009 21:38:55 -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 71908-01 for ; Fri, 11 Dec 2009 01:38:47 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f226.google.com (mail-ew0-f226.google.com [209.85.219.226]) by mail.postgresql.org (Postfix) with ESMTP id 3A5726321EB for ; Thu, 10 Dec 2009 21:38:46 -0400 (AST) Received: by ewy26 with SMTP id 26so548274ewy.3 for ; Thu, 10 Dec 2009 17:38:45 -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=f6b1hAgHw3tddxP9Ks2M9vcrObbW1REJWCAvJnxvjGw=; b=Vuqj4dk2H1u28Y3JLOi+zroxEHZ4v/St4M0HFYgysWeSLKVIQ39FJrCO/hua4aiaVX EuzEgV+7uU0YPyIcZ5u7LsVuy/E+9cTDbB8DIakXiyq+0t4Y+iuc7274WCmmWoPFOnf+ EcsTXny7DugKyyktYHrXP/bWa9BkVFVy1uzBw= 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=s6I3SkTaGYBvmtIqTqj9smuGaqH18sBQTDlZHvTbJuZ51VD4bwxoszL873rsqtuWHY Lj8Q1rfFz0ZX9cCmARrmdoZysUdgreJyxsZoCFN2ucXtyQ2svdXJoYf+WseM5faeqqwE s9IohdHjJy+dn0f+LxYZVymnA0QJ5FZiKjohU= MIME-Version: 1.0 Received: by 10.216.88.14 with SMTP id z14mr318063wee.25.1260495525120; Thu, 10 Dec 2009 17:38:45 -0800 (PST) In-Reply-To: <200912102309.04057.andres@anarazel.de> References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <200912102256.59868.andres@anarazel.de> <4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com> <200912102309.04057.andres@anarazel.de> From: Nikolas Everett Date: Thu, 10 Dec 2009 20:38:25 -0500 Message-ID: Subject: Re: 8.4.1 ubuntu karmic slow createdb To: Andres Freund Cc: pgsql-performance@postgresql.org, Michael Clemmons Content-Type: multipart/alternative; boundary=0016e6d7e925040a21047a69fc79 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/149 X-Sequence-Number: 36763 --0016e6d7e925040a21047a69fc79 Content-Type: text/plain; charset=ISO-8859-1 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. On Thu, Dec 10, 2009 at 5:09 PM, Andres Freund wrote: > Hi, > > On Thursday 10 December 2009 23:01:08 Michael Clemmons wrote: > > Im not sure what that means ppl in my office with slower hd speeds using > > 8.4 can create a db in 2s vs my 8-12s. > - Possibly their config is different - they could have disabled the "fsync" > parameter which turns the database to be not crashsafe anymore but much > faster > in some circumstances. > > - Possibly you have much data in your template1 database? > You could check whether > > CREATE DATABASE speedtest TEMPLATE template1; takes more time than > CREATE DATABASE speedtest TEMPLATE template0;. > > You should issue both multiple times to ensure caching on the template > database doesnt play a role. > > > Could using md5 instead of ident do it? > Seems unlikely. > Is starting psql near-instantaneus? Are you using "createdb" or are you > issuing "CREATE DATABASE ..."? > > Andres > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > --0016e6d7e925040a21047a69fc79 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable In my limited experience ext4 as presented by Karmic is not db friendly. = =A0I had to carve my swap partition into a swap partition and an xfs partit= ion to get better db performance. =A0Try fsync=3Doff first, but if that doe= sn't work then try a mini xfs.


On Thu, Dec 10, 2009 at 5:09 = PM, Andres Freund <andres@anarazel.de> wrote:
Hi,

On Thursday 10 December 2009 23:01:08 Michael Clemmons wrote:
> Im not sure what that means ppl in my office with slower hd speeds usi= ng
> =A08.4 can create a db in 2s vs my 8-12s.
- Possibly their config is different - they could have disabled the &= quot;fsync"
parameter which turns the database to be not crashsafe anymore but much fas= ter
in some circumstances.

- Possibly you have much data in your template1 database?
You could check whether

CREATE DATABASE speedtest TEMPLATE template1; takes more time than
CREATE DATABASE speedtest TEMPLATE template0;.

You should issue both multiple times to ensure caching on the template
database doesnt play a role.

> =A0Could using md5 instead of ident do it?
Seems unlikely.
Is starting psql near-instantaneus? Are you using "createdb" or a= re you
issuing "CREATE DATABASE ..."?

Andres

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

--0016e6d7e925040a21047a69fc79--