From: Luke Lonergan <llonergan@greenplum.com>
To: Milen Kulev <makulev@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: XFS filessystem for Datawarehousing
Date: Tue, 01 Aug 2006 19:42:37 -0700
Message-ID: <C0F55F2D.2B856%llonergan@greenplum.com> (raw)
In-Reply-To: <012d01c6b5b4$6db33680$0a00a8c0@trivadis.com>
Milen,
On 8/1/06 2:49 PM, "Milen Kulev" <makulev@gmx.net> wrote:
> Is anyone using XFS for storing/retrieving relatively large amount of data (~
> 200GB)?
I concur with the previous poster's experiences with one additional
observation:
We have had instabilities with XFS with software RAID (md) on 32-bit Xeons
running RedHat4 U3 with the Centos 4.3 unsupported SMP kernel. XFS would
occasionally kernel panic under load.
We have had no problems with XFS running on the same OS/kernel on 64-bit
under heavy workloads for weeks of continuous usage. Each server (of 16
total) had four XFS filesystems, each with 250GB of table data (no indexes)
on them, total of 16 Terabytes. We tested with the TPC-H schema and
queries.
We use the default settings for XFS.
Also - be aware that LVM has a serious performance bottleneck at about
600MB/s - if you are working below that threshold, you may not notice the
issue, maybe some increase in CPU consumption as you approach it.
- Luke
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: llonergan@greenplum.com, makulev@gmx.net
Subject: Re: XFS filessystem for Datawarehousing
In-Reply-To: <C0F55F2D.2B856%llonergan@greenplum.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