X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DB308D1B432 for ; Sun, 2 May 2004 05:10:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38484-04 for ; Sun, 2 May 2004 05:10:03 -0300 (ADT) Received: from roam.unifiedmind.com (unifiedmind.com [209.164.72.58]) by svr1.postgresql.org (Postfix) with SMTP id 12BCFD1C4C4 for ; Sun, 2 May 2004 05:10:01 -0300 (ADT) Received: (qmail 20259 invoked from network); 2 May 2004 08:31:20 -0000 Received: from unknown (HELO jamesthornton.com) (james@69.150.60.163) by 0 with SMTP; 2 May 2004 08:31:20 -0000 Message-ID: <4094AD20.6090707@jamesthornton.com> Date: Sun, 02 May 2004 03:11:12 -0500 From: James Thornton User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Recommended File System Configuration Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/8 X-Sequence-Number: 6839 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