Re: [ADMIN] v7.1b4 bad performance - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [ADMIN] v7.1b4 bad performance
Date
Msg-id 200102181959.OAA02190@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
> 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.

According to the BSD4.4 book by Karels/McKusick, even though computers
are faster now, increasing the Hz doesn't seem to improve performance.
This is probably because of cache misses from context switches.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: beta5 ...
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: WAL and commit_delay