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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-performance by date

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