Re: Perfomance Tuning - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Perfomance Tuning
Date
Msg-id 1060372003.97914.54.camel@jester
Whole thread Raw
In response to Re: Perfomance Tuning  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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.

Attachment

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Perfomance Tuning
Next
From: Andrew Sullivan
Date:
Subject: Re: Perfomance Tuning