Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group