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

Re: 8.4.1 ubuntu karmic slow createdb

From: Nikolas Everett <nik9000(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org, Michael Clemmons <glassresistor(at)gmail(dot)com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: 2009-12-11 01:38:25
Message-ID: d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
In my limited experience ext4 as presented by Karmic is not db friendly.  I
had to carve my swap partition into a swap partition and an xfs partition to
get better db performance.  Try fsync=off first, but if that doesn't work
then try a mini xfs.


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

> Hi,
>
> On Thursday 10 December 2009 23:01:08 Michael Clemmons wrote:
> > 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.
> - Possibly their config is different - they could have disabled the "fsync"
> parameter which turns the database to be not crashsafe anymore but much
> faster
> in some circumstances.
>
> - Possibly you have much data in your template1 database?
> You could check whether
>
> CREATE DATABASE speedtest TEMPLATE template1; takes more time than
> CREATE DATABASE speedtest TEMPLATE template0;.
>
> You should issue both multiple times to ensure caching on the template
> database doesnt play a role.
>
> >  Could using md5 instead of ident do it?
> Seems unlikely.
> Is starting psql near-instantaneus? Are you using "createdb" or are you
> issuing "CREATE DATABASE ..."?
>
> Andres
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

pgsql-performance by date

Next:From: Scott CareyDate: 2009-12-11 02:37:16
Subject: Re: Load experimentation
Previous:From: Scott CareyDate: 2009-12-10 23:29:59
Subject: Re: Load experimentation

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2009-12-11 01:39:54
Subject: Re: YAML Was: CommitFest status/management
Previous:From: Bruce MomjianDate: 2009-12-11 01:31:28
Subject: Re: thread safety on clients

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