From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: XFS filessystem for Datawarehousing
Date: Wed, 02 Aug 2006 19:33:39 -0400
Message-ID: <20060802233336.GN2900@mathom.us> (raw)
In-Reply-To: <721b21dc0608021426p26d2a79ap37e0f55b2328b453@mail.gmail.com>
References: <C0F55F2D.2B856%llonergan@greenplum.com>
<01cb01c6b676$8ef67330$0a00a8c0@trivadis.com>
<721b21dc0608021426p26d2a79ap37e0f55b2328b453@mail.gmail.com>
On Wed, Aug 02, 2006 at 02:26:39PM -0700, Steve Poe wrote:
>For the past year, I have been running odbc-bench on a dual-opteron with
>4GB of RAM using a 8GB sample data. I found the performance difference
>between EXT3, JFS, and XFS is +/- 5-8%.
That's not surprising when your db is only 2x your RAM. You'll find that
filesystem performance is much more important when your database is 10x+
your RAM (which is often the case once your database heads toward a TB).
>Testing newer kernels and read-ahead patches may benefit you as well.
I've been really impressed by the adaptive readahead patches with
postgres.
Mike Stone
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: mstone+postgres@mathom.us
Subject: Re: XFS filessystem for Datawarehousing
In-Reply-To: <20060802233336.GN2900@mathom.us>
* 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