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

Re: 8.4.1 ubuntu karmic slow createdb

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: Michael Clemmons <glassresistor(at)gmail(dot)com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: 2009-12-10 22:09:03
Message-ID: 200912102309.04057.andres@anarazel.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Scott CareyDate: 2009-12-10 23:29:59
Subject: Re: Load experimentation
Previous:From: Michael ClemmonsDate: 2009-12-10 22:01:08
Subject: Re: 8.4.1 ubuntu karmic slow createdb

pgsql-hackers by date

Next:From: David P. QuigleyDate: 2009-12-10 22:13:18
Subject: Re: Adding support for SE-Linux security
Previous:From: Tom LaneDate: 2009-12-10 22:08:17
Subject: Re: Adding support for SE-Linux security

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