Re: How to setup disk spindles for best performance - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: How to setup disk spindles for best performance
Date
Msg-id 48AD022E.7090400@commandprompt.com
Whole thread Raw
In response to Re: How to setup disk spindles for best performance  (Christiaan Willemsen <cwillemsen@technocon.com>)
Responses Re: How to setup disk spindles for best performance  (Christiaan Willemsen <cwillemsen@technocon.com>)
List pgsql-performance
Christiaan Willemsen wrote:
> So, what you are basically saying, is that a single mirror is in general
> more than enough to facilitate the transaction log.


http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/
http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide

And to answer your question, yes. Transaction logs are written
sequentially. You do not need a journaled file system and raid 1 is
plenty for most if not all work loads.

Sincerely,

Joshua D. Drake

pgsql-performance by date:

Previous
From: Christiaan Willemsen
Date:
Subject: Re: How to setup disk spindles for best performance
Next
From: "Kranti K K Parisa™"
Date:
Subject: Re: PostgreSQL+Hibernate Performance