Saturday, July 5, 2008

[PERFORM] filesystem options for WAL

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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

No comments: