Recommended File System Configuration

From: James Thornton <james(at)jamesthornton(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Recommended File System Configuration
Date: 2004-05-02 08:11:12
Message-ID: 4094AD20.6090707@jamesthornton.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jochem van Dieten 2004-05-02 14:30:47 Re: planner/optimizer question
Previous Message Manfred Koizar 2004-05-02 08:03:36 Re: planner/optimizer question