From: | "Priem, Alexander" <ap(at)cict(dot)nl> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | data=writeback |
Date: | 2004-04-08 07:59:18 |
Message-ID: | 2A07EC2D0BC2774AAD6F74769F60D52A0832C6@ahmose.cict_ad.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2004-04-08 08:54:39 | Re: good pc but bad performance,why? |
Previous Message | Grega Bremec | 2004-04-08 04:33:04 | Re: [PERFORM] Raw devices vs. Filesystems |