filesystem options for WAL - Mailing list pgsql-performance

From Jaime Casanova
Subject filesystem options for WAL
Date
Msg-id 3073cc9b0807052204j14efa56ft113b50013cacddcf@mail.gmail.com
Whole thread Raw
Responses Re: filesystem options for WAL  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Hi,

Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I read:
"""
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)

--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157

pgsql-performance by date:

Previous
From: "Sergio Gabriel Rodriguez"
Date:
Subject: Re: Subquery WHERE IN or WHERE EXISTS faster?
Next
From: "Scott Marlowe"
Date:
Subject: Re: How much work_mem to configure...