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

help / color / mirror / Atom feed

From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Tue, 29 Dec 2009 00:57:42 +0100
Message-ID: <hhbglj$2vc$1@ger.gmane.org> (raw)
In-Reply-To: <4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<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>
	<d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com>
	<d3ab2ec80912111359s47925b0dl7ce54b849767bacc@mail.gmail.com>
	<4B22CA3A.1040909@2ndquadrant.com>
	<4427a97a0912111452m35552852ub7c3fe30f8191849@mail.gmail.com>

Michael Clemmons wrote on 11.12.2009 23:52:
> 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.  Createdb
> takes 12secs on my system(9.10 pg8.4 and ext4)  which is impossibly slow
> for running 200unittests.

I wonder if you could simply create one database, and then a new schema for each of the tests.

After creating the schema you could alter the search_path for the "unit test user" and it would look like a completely new database.

Thomas

view thread (22+ messages)

Message-ID: <hhbglj$2vc$1@ger.gmane.org>
Permalink:  ../hhbglj$2vc$1@ger.gmane.org/
Also on:    postgresql.org/message-id/hhbglj$2vc$1@ger.gmane.org

copy link · copy postgr.es

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: spam_eater@gmx.net, pgsql-performance@postgresql.org
  Subject: Re: 8.4.1 ubuntu karmic slow createdb
  In-Reply-To: <hhbglj$2vc$1@ger.gmane.org>

* 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