Re: v7.1b4 bad performance - Mailing list pgsql-admin

From Dmitry Morozovsky
Subject Re: v7.1b4 bad performance
Date
Msg-id Pine.BSF.4.21.0102182231580.16523-100000@woozle.rinet.ru
Whole thread Raw
In response to Re: v7.1b4 bad performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Curt Sampson
Date:
Subject: Re: memory strangeness (fwd)
Next
From: Kris Kiger
Date:
Subject: tsearch2 poor performance