Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 324A86335F3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 10 Dec 2009 18:09:15 -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 41909-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 10 Dec 2009 22:09:07 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40])
	by mail.postgresql.org (Postfix) with ESMTP id D423C63331A
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Dec 2009 18:09:07 -0400 (AST)
Received: from alap2.localnet (e178225136.adsl.alicedsl.de [85.178.225.136])
	by mail.anarazel.de (Postfix) with ESMTPSA id 1475C44800A;
	Thu, 10 Dec 2009 23:09:05 +0100 (CET)
From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Thu, 10 Dec 2009 23:09:03 +0100
User-Agent: KMail/1.13.0 (Linux/2.6.32-andres-00908-g6ec22f9; KDE/4.3.80;
	x86_64; ; )
Cc: Michael Clemmons <glassresistor@gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<200912102256.59868.andres@anarazel.de>
	<4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
In-Reply-To: <4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <200912102309.04057.andres@anarazel.de>
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/147
X-Sequence-Number: 36761

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