Recommended File System Configuration - Mailing list pgsql-performance

From James Thornton
Subject Recommended File System Configuration
Date
Msg-id 4094AD20.6090707@jamesthornton.com
Whole thread Raw
List pgsql-performance
Back in 2001, there was a lengthy thread on the PG Hackers list about PG
and journaling file systems
(http://archives.postgresql.org/pgsql-hackers/2001-05/msg00017.php), but
there was no decisive conclusion regarding what FS to use. At the time
the fly in the XFS ointment was that deletes were slow, but this was
improved with XFS 1.1.

I think a journaling a FS is needed for PG data since large DBs could
take hours to recover on a non-journaling FS, but what about WAL files?

--

  James Thornton
______________________________________________________
Internet Business Consultant, http://jamesthornton.com



pgsql-performance by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: planner/optimizer question
Next
From: "Jochem van Dieten"
Date:
Subject: Re: planner/optimizer question