Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 843EB650689 for ; Sun, 6 Jul 2008 02:04:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44455-08 for ; Sun, 6 Jul 2008 02:04:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.232]) by postgresql.org (Postfix) with ESMTP id 84490650688 for ; Sun, 6 Jul 2008 02:04:32 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id c8so95106qbc.39 for ; Sat, 05 Jul 2008 22:04:31 -0700 (PDT) Received: by 10.141.50.11 with SMTP id c11mr1403988rvk.222.1215320671111; Sat, 05 Jul 2008 22:04:31 -0700 (PDT) Received: by 10.140.174.7 with HTTP; Sat, 5 Jul 2008 22:04:31 -0700 (PDT) Message-ID: <3073cc9b0807052204j14efa56ft113b50013cacddcf@mail.gmail.com> Date: Sun, 6 Jul 2008 00:04:31 -0500 From: "Jaime Casanova" To: "psql performance list" Subject: filesystem options for WAL MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.163 tagged_above=0 required=5 tests=AWL=1.163 X-Spam-Level: * X-Archive-Number: 200807/54 X-Sequence-Number: 30654 Hi, Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I re= ad: """ Combining these two, an optimal fstab for the WAL might look like this: /dev/hda2 /var ext3 defaults,writeback,noatime 1 2 """ Is this info accurate? I also read on other document from the "technical documentation" that for partitions where you have the tables and indexes is better to have journaling and for partitions for the WAL is better to not have journalling... i tought it has to be the other way (tables & indices without journalling, WAL with journalling) --=20 regards, Jaime Casanova Soporte y capacitaci=F3n de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157