Re: 10K vs 15k rpm for analytics - Mailing list pgsql-performance

From Greg Smith
Subject Re: 10K vs 15k rpm for analytics
Date
Msg-id 4B95F222.6040504@2ndquadrant.com
Whole thread Raw
In response to Re: 10K vs 15k rpm for analytics  (Scott Carey <scott@richrelevance.com>)
Responses Re: 10K vs 15k rpm for analytics
Re: 10K vs 15k rpm for analytics
List pgsql-performance
Scott Carey wrote:
> For high sequential throughput, nothing is as optimized as XFS on Linux yet.  It has weaknesses elsewhere however.
>

I'm curious what you feel those weaknesses are.  The recent addition of
XFS back into a more mainstream position in the RHEL kernel as of their
5.4 update greatly expands where I can use it now, have been heavily
revisiting it since that release.  I've already noted how well it does
on sequential read/write tasks relative to ext3, and it looks like the
main downsides I used to worry about with it (mainly crash recovery
issues) were also squashed in recent years.

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


pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: 10K vs 15k rpm for analytics
Next
From: Vidhya Bondre
Date:
Subject: Out of shared memory in postgres 8.4.2 and locks