Re: I have a fusion IO drive available for testing

Список
Период
Сортировка
От Jeff
Тема Re: I have a fusion IO drive available for testing
Дата
Msg-id F815CE00-9482-4B77-926D-07E459114D35@torgo.978.org
обсуждение исходный текст
Ответ на Re: I have a fusion IO drive available for testing  ()
Список pgsql-performance
Дерево обсуждения
I have a fusion IO drive available for testing  (Dave Cramer, )
 Re: I have a fusion IO drive available for testing  (Luke Lonergan, )
 Re: I have a fusion IO drive available for testing  ("Kenny Gorman", )
 Re: I have a fusion IO drive available for testing  (Jeff, )
 Re: I have a fusion IO drive available for testing  (, )
  Re: I have a fusion IO drive available for testing  (Jeff, )
  Re: I have a fusion IO drive available for testing  (David Rees, )
   Re: I have a fusion IO drive available for testing  (Dave Cramer, )
    Re: I have a fusion IO drive available for testing  (Craig James, )
 Re: I have a fusion IO drive available for testing  (Chris Browne, )
On Mar 27, 2009, at 1:30 PM,  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 <>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/




В списке pgsql-performance по дате отправления:

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: Re: Very specialised query
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4