Re: 8.4.1 ubuntu karmic slow createdb

[Nikolas Everett <nik9000@xxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance