Skip site navigation (1) Skip section navigation (2)

Re: 8.4.1 ubuntu karmic slow createdb

From: Michael Clemmons <glassresistor(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: 2009-12-10 22:01:08
Message-ID: 4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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.  Could using md5 instead of ident do it?

On Thu, Dec 10, 2009 at 4:56 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:

> On Thursday 10 December 2009 21:41:08 Michael Clemmons wrote:
> > Hey,
> > I've got a computer which runs but 8.3 and 8.4.  To create a db it takes
> 4s
> > for 8.3 and 9s for 8.4.  I have many unit tests which create databases
> all
> > of the time and now run much slower than 8.3 but it seems to be much
> longer
> > as I remember at one point creating databases I considered an
> instantaneous
> > thing.  Does any on the list know why this is true and if I can get it
> back
> > to normal.
> Possibly you had fsync=off at the time?
>
> Andres
>

In response to

Responses

pgsql-performance by date

Next:From: Andres FreundDate: 2009-12-10 22:09:03
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Previous:From: Andres FreundDate: 2009-12-10 21:56:59
Subject: Re: 8.4.1 ubuntu karmic slow createdb

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-12-10 22:08:17
Subject: Re: Adding support for SE-Linux security
Previous:From: Andres FreundDate: 2009-12-10 21:56:59
Subject: Re: 8.4.1 ubuntu karmic slow createdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group