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.
