Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 02EF4632CD3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 11 Dec 2009 16:50:24 -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 06800-08
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 11 Dec 2009 20:50:09 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 5F33E632A1B
	for <pgsql-performance@postgresql.org>;
	Fri, 11 Dec 2009 16:50:13 -0400 (AST)
Received: from [71.94.248.88] (unknown [71.94.248.88])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 7A9A5348045;
	Fri, 11 Dec 2009 12:50:11 -0800 (PST)
Subject: Re: 8.4.1 ubuntu karmic slow createdb
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Nikolas Everett <nik9000@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, pgsql-performance@postgresql.org,
	Michael Clemmons <glassresistor@gmail.com>
In-Reply-To: <d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<200912102256.59868.andres@anarazel.de>
	<4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
	<200912102309.04057.andres@anarazel.de>
	<d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>
	<1260554319.2611.10.camel@jd-desktop.unknown.charter.com>
	<d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Fri, 11 Dec 2009 12:50:10 -0800
Message-ID: <1260564610.2611.41.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.474 tagged_above=-10 required=5 tests=AWL=0.125,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200912/153
X-Sequence-Number: 36767

On Fri, 2009-12-11 at 15:43 -0500, Nikolas Everett wrote:
> 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.

My experience is that bad dev practices turn into bad production
practices, whether intentionally or not.

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