Re: Best use of second controller with faster disks? - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Best use of second controller with faster disks?
Date
Msg-id cone.1182281762.41078.90929.5001@35st.simplicato.com
Whole thread Raw
In response to Best use of second controller with faster disks?  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies
Next
From: Josh Berkus
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies