pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nikolas Everett <nik9000@gmail.com>
To: jd@commandprompt.com
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-performance@postgresql.org, Michael Clemmons <glassresistor@gmail.com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Fri, 11 Dec 2009 16:39:34 -0500
Message-ID: <d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com> (raw)
In-Reply-To: <1260564610.2611.41.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>
	<d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>
	<1260554319.2611.10.camel@jd-desktop.unknown.charter.com>
	<d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com>
	<1260564610.2611.41.camel@jd-desktop.unknown.charter.com>

On Fri, Dec 11, 2009 at 3:50 PM, Joshua D. Drake <jd@commandprompt.com>wrote:

> 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.
>

Fair enough.  I'm of the opinion that developers need to have their unit
tests run fast.  If they aren't fast then your just not going to test as
much as you should.  If your unit tests *have* to createdb then you have to
do whatever you have to do to get it fast.  It'd probably be better if unit
tests don't create databases or alter tables at all though.

Regardless of what is going on on your dev box you really should leave fsync
on on your continuous integration, integration test, and QA machines.
They're what your really modeling your production on anyway.

view thread (22+ messages)  latest in thread

Message-ID: <d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com>
Permalink:  ../d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com/
Also on:    postgresql.org/message-id/d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nik9000@gmail.com, jd@commandprompt.com, andres@anarazel.de, glassresistor@gmail.com
  Subject: Re: 8.4.1 ubuntu karmic slow createdb
  In-Reply-To: <d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox