From: Florian Weimer <fweimer@bfk.de>
To: Koth, Christian (DWBI) <Christian.Koth@smiths-heimann.com>
Cc: Milen Kulev <makulev@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: XFS filessystem for Datawarehousing
Date: Thu, 03 Aug 2006 09:17:12 +0200
Message-ID: <8264haffuv.fsf@mid.bfk.de> (raw)
In-Reply-To: <F5F602C218633C419C7BCA6CDDC6E90A0248B0A8@COSSMGMBX04.EMAIL.CORP.TLD>
References: <F5F602C218633C419C7BCA6CDDC6E90A0248B0A8@COSSMGMBX04.EMAIL.CORP.TLD>
* Christian Koth:
> For what reason are you planning to use a journaling FS? I think
> using WAL, fsyncing every transaction and using a journaling FS is
> tautologous.
The journal is absolutely required to preserve the integrity of the
file system's own on-disk data structures after a crash. Even if
you've got a trustworthy file system checker (there are surprisingly
few of them, especially for advanced file systems without fixed data
structure locations), running it after a crash usually leads to
unacceptably high downtime.
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Durlacher Allee 47 tel: +49-721-96201-1
D-76131 Karlsruhe fax: +49-721-96201-99
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: fweimer@bfk.de, Christian.Koth@smiths-heimann.com, makulev@gmx.net
Subject: Re: XFS filessystem for Datawarehousing
In-Reply-To: <8264haffuv.fsf@mid.bfk.de>
* 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