Re: PostgreSQL on Solaris 8 and ufs

Поиск
Список
Период
Сортировка
От Brandon Metcalf
Тема Re: PostgreSQL on Solaris 8 and ufs
Дата
Msg-id Pine.LNX.4.58L.0503221505110.24435@cash.rhiamet.com
обсуждение исходный текст
Ответ на Re: PostgreSQL on Solaris 8 and ufs  (Alan Stange <stange@rentec.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Sven Willenberger
Дата:
Сообщение: Re: PostgreSQL on Solaris 8 and ufs
Следующее
От: "Brandon Metcalf"
Дата:
Сообщение: Re: PostgreSQL on Solaris 8 and ufs