data=writeback - Mailing list pgsql-performance

Hi everyone,

I have done some reading on filesystems and I thought to optimize the
settings for my PostgreSQL system. I use the ext3 filesystem and have the
PostgreSQL data and WAL on different physical drives. I made some
adjustments to my /etc/fstabd file, so it looks like this :


LABEL=/                 /                     ext3
noatime,data=ordered    1 1
LABEL=/boot             /boot                 ext3
noatime,data=ordered    1 2
none                    /dev/pts              devpts       gid=5,mode=620
0 0
none                    /proc                 proc         defaults
0 0
none                    /dev/shm              tmpfs        defaults
0 0
LABEL=/usr/local/pgsql  /usr/local/pgsql      ext3
noatime,data=writeback  1 2
LABEL=/usr/local/pgsql  /usr/local/pgsql/wal  ext3
noatime,data=ordered    1 2
/dev/sda5               swap                  swap         defaults
0 0
/dev/cdrom              /mnt/cdrom            udf,iso9660
noauto,owner,kudzu,ro   0 0
/dev/fd0                /mnt/floppy           auto
noauto,owner,kudzu      0 0


Does this look OK? My knowledge of filesystems and their (journalling)
options is not very broad...

Thanks in advance,
Alexander Priem.