Filesystem optimisation for postgresql tables and WAL logs on linux.

Hi,

I have got there SCSIs HDDs for the postgresql Box
i plan to install OS on 1st , 2nd for tables and indexes and third
for pg_xlog.

Bruce Momjian's "H/W Perf tuning" on
http://www.ca.postgresql.org/docs/momjian/hw_performance/node11.html
recommends 8k blocksize for the filesystem which is same as the page size.

On linux ext2 fs (on my server) 4096 is the default blocak size and 8192 bytes
is not supported.

but man mkfs.ext2 on linux mentions an option -T which is:
-T fs-type
Specify how the filesystem is going to be used, so that mke2fs can chose optimal filesystem parameters for that
use. The supported filesystem types are:
news one inode per 4kb block
largefile one inode per megabyte
largefile4 one inode per 4 megabytes

is the above relevent as far as optimisation for filesystem for tables is concerned?

Also for the pg_xlog drive is a particular block size more favourable then others?

regds
mallah.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.