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

Re: 8.4.1 ubuntu karmic slow createdb

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Nikolas Everett <nik9000(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-performance(at)postgresql(dot)org, Michael Clemmons <glassresistor(at)gmail(dot)com>
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Date: 2009-12-11 17:58:39
Message-ID: 1260554319.2611.10.camel@jd-desktop.unknown.charter.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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


In response to

Responses

pgsql-performance by date

Next:From: Nikolas EverettDate: 2009-12-11 20:43:59
Subject: Re: 8.4.1 ubuntu karmic slow createdb
Previous:From: Scott CareyDate: 2009-12-11 02:37:16
Subject: Re: Load experimentation

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2009-12-11 17:59:27
Subject: Re: Python 3.1 support
Previous:From: Robert HaasDate: 2009-12-11 17:55:50
Subject: Re: [PATCH] dtrace probes for memory manager

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