From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Cc: Michael Clemmons <glassresistor@gmail.com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Thu, 10 Dec 2009 23:09:03 +0100
Message-ID: <200912102309.04057.andres@anarazel.de> (raw)
In-Reply-To: <4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
<200912102256.59868.andres@anarazel.de>
<4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andres@anarazel.de, pgsql-performance@postgresql.org, glassresistor@gmail.com
Subject: Re: 8.4.1 ubuntu karmic slow createdb
In-Reply-To: <200912102309.04057.andres@anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox