Re: Perfomance Tuning

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Perfomance Tuning
Date: 2003-08-08 18:53:23
Message-ID: 20030808185323.GH2967@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 08, 2003 at 09:40:20AM -0700, Jonathan Gardner wrote:
>
> Redhat puts ext3 on by default. Consider switching to a non-journaling FS
> (ext2?) with the partition that holds your data and WAL.

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.

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2003-08-08 19:13:47 Re: Perfomance Tuning
Previous Message Manfred Koizar 2003-08-08 16:52:44 Index correlation (was: Moving postgresql.conf tunables into 2003... )