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

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Scott Carey <scott@richrelevance.com>
Cc: " <david@lang.hm>
Cc: " <david@lang.hm>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Francisco Reyes <lists@stringsutils.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: 10K vs 15k rpm for analytics
Date: Tue, 09 Mar 2010 21:32:38 -0500
Message-ID: <4B9704C6.5000209@2ndquadrant.com> (raw)
In-Reply-To: <2F90D51A-E3E4-4BCC-92BE-4CB2248CFA43@richrelevance.com>
References: <cone.1267562557.293175.32557.1000@shelca>
	<dcc563d11003021312k57e9c558n177e10ad16ab32b1@mail.gmail.com>
	<cone.1267565429.453229.32557.1000@shelca>
	<dcc563d11003021347h52f94812jf75b5937937a9ed4@mail.gmail.com>
	<alpine.DEB.2.00.1003021408340.5131@asgard.lang.hm>
	<06A22EB5-2D84-401C-B75F-7CA883695E0A@richrelevance.com>
	<4B95F222.6040504@2ndquadrant.com>
	<2F90D51A-E3E4-4BCC-92BE-4CB2248CFA43@richrelevance.com>

Scott Carey wrote:
> I'm also not sure how up to date RedHat's xfs version is -- there have been enhancements to xfs in the kernel mainline regularly for a long time.
>   

They seem to following SGI's XFS repo quite carefully and cherry-picking 
bug fixes out of there, not sure of how that relates to mainline kernel 
development right now.  For example:

https://bugzilla.redhat.com/show_bug.cgi?id=509902 (July 2009 SGI 
commit, now active for RHEL5.4)
https://bugzilla.redhat.com/show_bug.cgi?id=544349 (November 2009 SGI 
commit, may be merged into RHEL5.5 currently in beta)

Far as I've been able to tell this is all being driven wanting >16TB 
large filesystems, i.e. 
https://bugzilla.redhat.com/show_bug.cgi?id=213744 , and the whole thing 
will be completely mainstream (bundled into the installer, and hopefully 
with 32-bit support available) by RHEL6:  
https://bugzilla.redhat.com/show_bug.cgi?id=522180

Thanks for the comments.  From all the info I've been able to gather, 
"works fine for what PostgreSQL does with the filesystem, not 
necessarily suitable for your root volume" seems to be a fair 
characterization of where XFS is at right now.  Which is 
reasonable--that's the context I'm getting more requests to use it in, 
just as the filesystem for where the database lives.  Those who don't 
have a separate volume and filesystem for the db also tend not to care 
about filesystem performance differences either.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us




view thread (47+ messages)

Message-ID: <4B9704C6.5000209@2ndquadrant.com>
Permalink:  ../4B9704C6.5000209@2ndquadrant.com/
Also on:    postgresql.org/message-id/4B9704C6.5000209@2ndquadrant.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: greg@2ndquadrant.com, scott@richrelevance.com, david@lang.hm, scott.marlowe@gmail.com, lists@stringsutils.com
  Subject: Re: 10K vs 15k rpm for analytics
  In-Reply-To: <4B9704C6.5000209@2ndquadrant.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