Re: v7.1b4 bad performance

Поиск
Список
Период
Сортировка
От Dmitry Morozovsky
Тема Re: v7.1b4 bad performance
Дата
Msg-id Pine.BSF.4.21.0102182231580.16523-100000@woozle.rinet.ru
обсуждение исходный текст
Ответ на Re: v7.1b4 bad performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Sat, 17 Feb 2001, Tom Lane wrote:

[skip]

TL> Platform: HPUX 10.20 on HPPA C180, fast wide SCSI discs, 7200rpm (I think).
TL> Minimum select(2) delay is 10 msec on this platform.

[skip]

TL> I vote for commit_delay = 0, unless someone can show cases where
TL> positive delay is significantly better than zero delay.

BTW, for modern versions of FreeBSD kernels, there is HZ kernel option
which describes maximum timeslice granularity (actually, HZ value is
number of timeslice periods per second, with default of 100 = 10 ms). On
modern CPUs HZ may be increased to at least 1000, and sometimes even to
5000 (unfortunately, I haven't test platform by hand).

So, maybe you can test select granularity at ./configure phase and then
define default commit_delay accordingly.

Your thoughts?

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------



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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: memory strangeness (fwd)
Следующее
От: Kris Kiger
Дата:
Сообщение: tsearch2 poor performance