pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Michael Clemmons <glassresistor@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Fri, 11 Dec 2009 16:59:13 -0700
Message-ID: <dcc563d10912111559t4e2524di14369c2b4e3d802c@mail.gmail.com> (raw)
In-Reply-To: <4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@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>
	<d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com>
	<d3ab2ec80912111359s47925b0dl7ce54b849767bacc@mail.gmail.com>
	<4B22CA3A.1040909@2ndquadrant.com>
	<4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com>

On Fri, Dec 11, 2009 at 3:52 PM, Michael Clemmons
<glassresistor@gmail.com> 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.

>  Createdb takes
> 12secs on my system(9.10 pg8.4 and ext4)  which is impossibly slow for
> running 200unittests.

Wait, so each unit test createdbs by itself?  Wow...

>  Fsync got it to .2secs or so which is blazing but
> also the speed I expected being used to 8.3 and xfs.  This dev box is my
> laptop and the data is litterally unimportant and doesn't exist longer than
> 20sec but Im all about good practices.  Will definately try synchronous
> commit tonight once Im done working for the day.  I've got some massive
> copying todo later though so this will probably help in the future as well.

Yeah, I'd probably resort to fsync off in that circumstance too
especially if syn commit off didn't help that much.



view thread (22+ messages)  latest in thread

Message-ID: <dcc563d10912111559t4e2524di14369c2b4e3d802c@mail.gmail.com>
Permalink:  ../dcc563d10912111559t4e2524di14369c2b4e3d802c@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10912111559t4e2524di14369c2b4e3d802c@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: scott.marlowe@gmail.com, glassresistor@gmail.com, pgsql-performance@postgresql.org
  Subject: Re: 8.4.1 ubuntu karmic slow createdb
  In-Reply-To: <dcc563d10912111559t4e2524di14369c2b4e3d802c@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