Re: Perfomance Tuning

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Perfomance Tuning
Date: 2003-08-08 19:46:44
Message-ID: 1060372003.97914.54.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > 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.

Yes, UFS(2) is an excellent filesystem for PostgreSQL, especially if you
can use background fsck & softupdates.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-08 19:56:58 Re: Perfomance Tuning
Previous Message Bruce Momjian 2003-08-08 19:34:44 Re: Perfomance Tuning