From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Rod Taylor <rbt@rbt.ca>
Cc: Andrew Sullivan <andrew@libertyrms.info>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Perfomance Tuning
Date: Fri, 08 Aug 2003 16:13:47 -0400
Message-ID: <29638.1060373627@sss.pgh.pa.us> (raw)
In-Reply-To: <200308081934.h78JYi906553@candle.pha.pa.us>
References: <200308081934.h78JYi906553@candle.pha.pa.us>
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Rod Taylor wrote:
>> On Fri, 2003-08-08 at 14:53, Andrew Sullivan wrote:
>>> I would give you exactly the opposite advice: _never_ use a
>>> non-journalling fs for your data and WAL. I suppose if you can
>>> afford to lose some transactions, you can do without journalling.
>>> Otherwise, you're just borrowing trouble, near as I can tell.
>>
>> Agreed.. WAL cannot recover something when WAL no longer exists due to a
>> filesystem corruption.
> It is true that ext2 isn't good because the file system may not recover,
> but BSD UFS isn't a journalled file system, but does guarantee file
> system recovery after a crash --- it is especially good using soft
> updates.
The main point here is that the filesystem has to be able to take care
of itself; we expect it not to lose any files or forget where the data
is. If it wants to use journalling to accomplish that, fine.
Journalling file contents updates, as opposed to filesystem metadata,
should be redundant with what we do in WAL. So I'd recommend
journalling metadata only, if that option is available (and if Postgres
stuff is the only stuff on the disk...)
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us, rbt@rbt.ca, andrew@libertyrms.info
Subject: Re: Perfomance Tuning
In-Reply-To: <29638.1060373627@sss.pgh.pa.us>
References: <200308081934.h78JYi906553@candle.pha.pa.us> <29638.1060373627@sss.pgh.pa.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