From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
---|---|
To: | "Milen Kulev" <makulev(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: XFS filessystem for Datawarehousing |
Date: | 2006-08-02 02:42:37 |
Message-ID: | C0F55F2D.2B856%llonergan@greenplum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Milen,
On 8/1/06 2:49 PM, "Milen Kulev" <makulev(at)gmx(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2006-08-02 02:44:20 | Re: XFS filessystem for Datawarehousing -2 |
Previous Message | Mark Kirkwood | 2006-08-02 02:06:11 | Re: XFS filessystem for Datawarehousing |