Re: How to setup disk spindles for best performance

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Christiaan Willemsen <cwillemsen(at)technocon(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to setup disk spindles for best performance
Date: 2008-08-21 05:50:38
Message-ID: 48AD022E.7090400@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kranti K K Parisa™ 2008-08-21 06:59:38 Re: PostgreSQL+Hibernate Performance
Previous Message Christiaan Willemsen 2008-08-21 05:38:39 Re: How to setup disk spindles for best performance