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
forthat 
              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.