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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
