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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2009-12-11 01:39:54 | Re: YAML Was: CommitFest status/management |
Previous Message | Bruce Momjian | 2009-12-11 01:31:28 | Re: thread safety on clients |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Carey | 2009-12-11 02:37:16 | Re: Load experimentation |
Previous Message | Scott Carey | 2009-12-10 23:29:59 | Re: Load experimentation |