Re: Perfomance Tuning

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Perfomance Tuning
Date: 2003-08-08 19:56:58
Message-ID: 20030808195658.GJ2967@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 08, 2003 at 03:34:44PM -0400, Bruce Momjian wrote:
>
> 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.

Sorry. I usually write "journalled or equivalent" for this reason.
I think UFS with soft updates is a good example of this. You also
don't need complete journalling in most cases -- metadata is probably
sufficient, given fsync.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-08-08 20:13:47 Re: Perfomance Tuning
Previous Message Rod Taylor 2003-08-08 19:46:44 Re: Perfomance Tuning