From: | Nikolas Everett <nik9000(at)gmail(dot)com> |
---|---|
To: | jd(at)commandprompt(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 20:43:59 |
Message-ID: | d4e11e980912111243s6b0a67b1u2c2c22031fadf756@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
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(at)commandprompt(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-12-11 20:50:10 | Re: 8.4.1 ubuntu karmic slow createdb |
Previous Message | Stephen Frost | 2009-12-11 20:28:12 | Re: Adding support for SE-Linux security |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-12-11 20:50:10 | Re: 8.4.1 ubuntu karmic slow createdb |
Previous Message | Joshua D. Drake | 2009-12-11 17:58:39 | Re: 8.4.1 ubuntu karmic slow createdb |