data=writeback

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.

Responses

Browse pgsql-performance by date

  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