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

Thanks Joshua,

So what about putting the indexes on a separate array? Since we do a lot
of inserts indexes are going to be worked on a lot of the time.

Regards,

Christiaan

Joshua D. Drake wrote:
> 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
>