View Single Post

   
  #7 (permalink)  
Old 04-19-2008, 11:02 AM
Francisco Reyes
 
Posts: n/a
Default Re: Best use of second controller with faster disks?

Vivek Khera writes:

> no file will ever be larger than 1Gb I didn't need to make any
> adjustments to the newfs parameters.


You should consider using "newfs -i 65536" for partitions to be used for
postgresql. You will get more usable space and will still have lots of free
inodes.

For my next postgresql server I am likely going to do "newfs -i 262144"

On my current primary DB I have 2049 inodes in use and 3,539,389 free.
That was with newfs -i 65536.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote