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

help / color / mirror / Atom feed

From: Michael Stone <mstone+postgres@mathom.us>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: Tue, 18 Mar 2008 07:04:21 -0400
Message-ID: <20080318110419.GG2626@mathom.us> (raw)
In-Reply-To: <47DD6F4C.2050208@emolecules.com>
References: <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>
	<47DD6F4C.2050208@emolecules.com>

On Sun, Mar 16, 2008 at 12:04:44PM -0700, Craig James wrote:
>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?

For the WAL, the filesystem is largely irrelevant. (It's relatively 
small, the files are preallocated, the data is synced to disk so there's 
not advantage from write buffering, etc.) The best filesystem is one 
that does almost nothing and stays out of the way--ext2 is a good choice 
for that. The data is a different story and a different filesystem is 
usually a better choice. (If for no other reason than to avoid long 
fsck times.)

Mike Stone

view thread (45+ messages)

Message-ID: <20080318110419.GG2626@mathom.us>
Permalink:  ../20080318110419.GG2626@mathom.us/
Also on:    postgresql.org/message-id/20080318110419.GG2626@mathom.us

copy link · copy postgr.es

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: mstone+postgres@mathom.us, craig_james@emolecules.com
  Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  In-Reply-To: <20080318110419.GG2626@mathom.us>

* 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