Re: PostgreSQL on Solaris 8 and ufs - Mailing list pgsql-performance

s == stange@rentec.com writes:

 s> Try setting
 s> set ufs:ufs_WRITES=0
 s> in /etc/system and rebooting, which basically says "any amount of disk
 s> IO can be outstanding".  There's a tunables doc on docs.sun.com that
 s> explains this option.

 s> Also, logging UFS might help with some of the metadata requirements of
 s> UFS as well.  So, use "mount -o logging" or add the relevant entry in
 s> /etc/vfstab.

OK.  I'll try these out.  We do have ufs_WRITES enabled with the
following parameters:

  set ncsize                      =   257024
  set autoup                      =       90
  set bufhwm                      =    15000
  set tune_t_fsflushr             =       15
  set ufs:ufs_HW                  = 16777216
  set ufs:ufs_LW                  =  8388608


--
Brandon