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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to