pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig James <craig_james@emolecules.com>
To: Dave Cramer <pg@fastcrypt.com>
Cc: Justin <justin@emproshunts.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: Sun, 16 Mar 2008 12:04:44 -0700
Message-ID: <47DD6F4C.2050208@emolecules.com> (raw)
In-Reply-To: <F38ADB71-8F77-41C8-9066-488FFCA7BD67@fastcrypt.com>
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
	<Pine.GSO.4.64.0803060813570.11897@westnet.com>
	<47D00DB2.7040007@emolecules.com>
	<18451.1204824562@sss.pgh.pa.us>
	<47D0AFC1.5070305@emolecules.com>
	<08115901408538@mail.emproshunts.com>
	<47D93A43.6020503@emolecules.com>
	<016301c8854e$851e06e0$3101a8c0@JDell>
	<dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com>
	<47DA1866.3050500@krogh.cc>
	<dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com>
	<47DA37E1.6050104@emproshunts.com>
	<Pine.GSO.4.64.0803140359220.20241@westnet.com>
	<47DA5852.30004@emproshunts.com>
	<47DCBBF9.1090401@emproshunts.com>
	<F38ADB71-8F77-41C8-9066-488FFCA7BD67@fastcrypt.com>

Dave Cramer wrote:
> 
> On 16-Mar-08, at 2:19 AM, Justin wrote:
> 
>>
>> I decided to reformat the raid 10 into ext2 to see if there was any 
>> real big difference in performance as some people have noted   here is 
>> the test results
>>
>> please note the WAL files are still on the raid 0 set which is still 
>> in ext3 file system format.  these test where run with the fsync as 
>> before.   I made sure every thing was the same as with the first test.
>>
> This is opposite to the way I run things. I use ext2 on the WAL and ext3 
> on the data. I'd also suggest RAID 10 on the WAL it is mostly write.

Just out of curiosity: Last time I did research, the word seemed to be that xfs was better than ext2 or ext3.  Is that not true?  Why use ext2/3 at all if xfs is faster for Postgres?

Criag



view thread (45+ messages)  latest in thread

Message-ID: <47DD6F4C.2050208@emolecules.com>
Permalink:  ../47DD6F4C.2050208@emolecules.com/
Also on:    postgresql.org/message-id/47DD6F4C.2050208@emolecules.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig_james@emolecules.com, pg@fastcrypt.com, justin@emproshunts.com, gsmith@gregsmith.com
  Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  In-Reply-To: <47DD6F4C.2050208@emolecules.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox