Re: XFS filessystem for Datawarehousing

От: Alvaro Herrera
Тема: Re: XFS filessystem for Datawarehousing
Дата: ,
Msg-id: 20060802004223.GE20401@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: XFS filessystem for Datawarehousing  ("J. Andrew Rogers")
Ответы: Re: XFS filessystem for Datawarehousing  ("Jim C. Nasby")
Список: pgsql-performance

Скрыть дерево обсуждения

XFS filessystem for Datawarehousing  ("Milen Kulev", )
 Re: XFS filessystem for Datawarehousing  ("Milen Kulev", )
 Re: XFS filessystem for Datawarehousing  ("J. Andrew Rogers", )
  Re: XFS filessystem for Datawarehousing  (Alvaro Herrera, )
   Re: XFS filessystem for Datawarehousing  ("Jim C. Nasby", )
    Re: XFS filessystem for Datawarehousing  (Alvaro Herrera, )
 Re: XFS filessystem for Datawarehousing  (Mark Kirkwood, )
 Re: XFS filessystem for Datawarehousing  ("Luke Lonergan", )
  Re: XFS filessystem for Datawarehousing  ("Milen Kulev", )
   Re: XFS filessystem for Datawarehousing  ("Steve Poe", )
    Re: XFS filessystem for Datawarehousing  ("Milen Kulev", )
    Re: XFS filessystem for Datawarehousing  (Michael Stone, )
     Re: XFS filessystem for Datawarehousing  ("Luke Lonergan", )
      Re: XFS filessystem for Datawarehousing  ("Milen Kulev", )
       Re: XFS filessystem for Datawarehousing  ("Luke Lonergan", )
  Re: XFS filessystem for Datawarehousing  (Chris Browne, )
 Re: XFS filessystem for Datawarehousing  ("Koth, Christian (DWBI)", )
  Re: XFS filessystem for Datawarehousing  (Florian Weimer, )
  Re: XFS filessystem for Datawarehousing  (Michael Stone, )

J. Andrew Rogers wrote:
>
> On Aug 1, 2006, at 2:49 PM, Milen Kulev wrote:
> >Is anyone using XFS for storing/retrieving relatively large amount
> >of data  (~ 200GB)?
>
>
> Yes, we've been using it on Linux since v2.4 (currently v2.6) and it
> has been rock solid on our database servers (Opterons, running in
> both 32-bit and 64-bit mode).  Our databases are not quite 200GB
> (maybe 75GB for a big one currently), but ballpark enough that the
> experience is probably valid.  We also have a few terabyte+ non-
> database XFS file servers too.
>
> Performance has been very good even with nearly full file systems,
> and reliability has been perfect so far. Some of those file systems
> get used pretty hard for months or years non-stop.  Comparatively, I
> can only tell you that XFS tends to be significantly faster than
> Ext3, but we never did any serious file system tuning either.

Most likely ext3 was used on the default configuration, which logs data
operations as well as metadata, which is what XFS logs.  I don't think
I've seen any credible comparison between XFS and ext3 with the
metadata-only journal option.

On the other hand I don't think it makes sense to journal data on a
PostgreSQL environment.  Metadata is enough, given that we log data on
WAL anyway.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Query/database optimization
От: Eugeny N Dzhurinsky
Дата:
Сообщение: Re: Query/database optimization