pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nikolas Everett <nik9000@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-performance@postgresql.org, Michael Clemmons <glassresistor@gmail.com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: Thu, 10 Dec 2009 20:38:25 -0500
Message-ID: <d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com> (raw)
In-Reply-To: <200912102309.04057.andres@anarazel.de>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<200912102256.59868.andres@anarazel.de>
	<4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
	<200912102309.04057.andres@anarazel.de>

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

view thread (22+ messages)  latest in thread

Message-ID: <d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>
Permalink:  ../d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com/
Also on:    postgresql.org/message-id/d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-hackers@postgresql.org
  Cc: nik9000@gmail.com, andres@anarazel.de, glassresistor@gmail.com
  Subject: Re: 8.4.1 ubuntu karmic slow createdb
  In-Reply-To: <d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>
  References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com> <200912102256.59868.andres@anarazel.de> <4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com> <200912102309.04057.andres@anarazel.de> <d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>

* 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