Re: PostgreSQL on Solaris 8 and ufs

s == sven(at)dmv(dot)com writes:

s> What are you using to create your raid?

Hm. I didn't set this up. I'll have to check.

s> You say it is "no doubt disk
s> I/O" - does iostat confirm this? A lot of performance issues are related
s> to the size of the stripe you chose for the striped portion of the
s> array, the actual array configuration, etc. I am assuming you have
s> looked at system variables such as autoup and the likes? What tweaks
s> have you done?

I've mainly been using Glance which shows a lot of queued requests for
the disks in question.

Here's currently what we have in /etc/system related to ufs:

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

s> Also, are your pg_xlog and data directories separated onto separate
s> volumes? Doing so will help immensely.

No, they are on the same volume.

s> What are you using to measure
s> performance?

Nothing too scientific other than the fact that since we have moved
the DB, we consistenly see a large number of postmater processes
(close to 100) where before we did not.

--
Brandon