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
>
>
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