X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 100D7D1C92B for ; Sat, 26 Jul 2003 14:12:41 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 39707-04 for ; Sat, 26 Jul 2003 11:11:55 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 017A9D1C4EB for ; Sat, 26 Jul 2003 11:12:40 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6QECZQ3009305; Sat, 26 Jul 2003 10:12:36 -0400 (EDT) To: "Arjen van der Meijden" Cc: "'Andrew McMillan'" , "'Alexander Priem'" , "'PgSQL Performance ML'" Subject: Re: Tuning PostgreSQL In-reply-to: <000001c3535f$4af7acd0$3ac15e91@acm> References: <000001c3535f$4af7acd0$3ac15e91@acm> Comments: In-reply-to "Arjen van der Meijden" message dated "Sat, 26 Jul 2003 12:18:37 +0200" Date: Sat, 26 Jul 2003 10:12:35 -0400 Message-ID: <9304.1059228755@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/427 X-Sequence-Number: 2720 "Arjen van der Meijden" writes: > Well, reboting is not a problem with ext2, but crashing might be... And > normally you don't plan a systemcrash ;) > Ext3 and xfs handle that much better. A journaling filesystem is good to use if you can set it to journal metadata but not file contents. PG's WAL logic can recover lost file contents, but we have no way to help out the filesystem if it's lost metadata. regards, tom lane