Re: PostgreSQL on Solaris 8 and ufs

s == stange(at)rentec(dot)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