pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nikolas Everett <nik9000@gmail.com>
To: jd@commandprompt.com
Cc: 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: Fri, 11 Dec 2009 15:43:59 -0500
Message-ID: <d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com> (raw)
In-Reply-To: <1260554319.2611.10.camel@jd-desktop.unknown.charter.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<200912102256.59868.andres@anarazel.de>
	<4427a97a0912101401kb29e1a5ic5424d6d0b7efe62@mail.gmail.com>
	<200912102309.04057.andres@anarazel.de>
	<d4e11e980912101738t77b654b2j1db1c023eafd9a58@mail.gmail.com>
	<1260554319.2611.10.camel@jd-desktop.unknown.charter.com>

Turning fsync off on a dev database is a bad idea?  Sure you might kill it
and have to start over, but thats kind of the point in a dev database.

On Fri, Dec 11, 2009 at 12:58 PM, Joshua D. Drake <jd@commandprompt.com>wrote:

> On Thu, 2009-12-10 at 20:38 -0500, Nikolas Everett wrote:
> > 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.
>
> Do not turn fsync off. That is bad advice. I would not suggest ext4 at
> this point for database operations. Use ext3. It is backward compatible.
>
> Joshua D. Drake
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> If the world pushes look it in the eye and GRR. Then push back harder. -
> Salamander
>
>

view thread (22+ messages)  latest in thread

Message-ID: <d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com>
Permalink:  ../d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com/
Also on:    postgresql.org/message-id/d4e11e980912111243s6b0a67b1u2c2c22031fadf756@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 using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nik9000@gmail.com, jd@commandprompt.com, andres@anarazel.de, glassresistor@gmail.com
  Subject: Re: 8.4.1 ubuntu karmic slow createdb
  In-Reply-To: <d4e11e980912111243s6b0a67b1u2c2c22031fadf756@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