Re: 8.4.1 ubuntu karmic slow createdb
Michael Clemmons <glassresistor@gmail.com>
From: Michael Clemmons <glassresistor@gmail.com>
To: pgsql-performance@postgresql.org
Date: 2009-12-10T22:01:08Z
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@anarazel.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 >