Re: I have a fusion IO drive available for testing - Mailing list pgsql-performance

From Jeff
Subject Re: I have a fusion IO drive available for testing
Date
Msg-id F815CE00-9482-4B77-926D-07E459114D35@torgo.978.org
Whole thread Raw
In response to Re: I have a fusion IO drive available for testing  (david@lang.hm)
List pgsql-performance
On Mar 27, 2009, at 1:30 PM, david@lang.hm wrote:

>
> for the WAL you definantly don't need the journal, for the data I'm
> not sure. I believe that postgres does appropriate fsync calls so is
> safe on a non-journaling filesystem. the fusionIO devices are small
> enough that a fsync on them does not take that long, so it may not
> be worth the overhead of the journaling.
>

The win for the journal on the heap is simply so you don't need to
spend $longtime fsck'ing if you crash, etc.

--
Jeff Trout <jeff@jefftrout.com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/




pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Very specialised query
Next
From: Tom Lane
Date:
Subject: Re: Very specialised query