filesystem options for WAL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux