From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Fredrik Estreen <estreen(at)algonet(dot)se>
Cc:
Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgman(at)candle(dot)pha(dot)pa(dot)us,
pgsql-hackers(at)postgresql(dot)org, jwbaker(at)acm(dot)org
Subject:
Re: LWLock contention: I think I understand the problem
Date:
2002-01-04 01:02:54
Message-ID:
1636.1010106174@sss.pgh.pa.us (view raw or flat )
Thread:
2001-12-29 19:10:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-29 19:24:02 from Thomas Lockhart <lockhart(at)fourpalms(dot)org>
2001-12-29 19:46:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-29 19:35:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-29 19:45:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-29 20:07:47 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-29 20:49:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-30 01:50:48 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-30 02:00:43 from "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
2001-12-30 02:13:36 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-30 02:42:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-30 02:30:23 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-30 07:53:09 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
2001-12-30 16:52:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-30 18:04:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-30 23:44:13 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 01:18:25 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
2002-01-03 07:55:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 09:00:10 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
2002-01-03 15:20:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-03 17:08:34 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 17:16:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 17:41:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-03 19:55:10 from Hannu Krosing <hannu(at)tm(dot)ee>
2002-01-03 23:39:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-04 11:45:43 from Hannu Krosing <hannu(at)tm(dot)ee>
2002-01-04 04:46:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-04 04:55:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-04 04:59:11 from "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
2002-01-04 05:02:29 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-03 19:37:17 from Hannu Krosing <hannu(at)tm(dot)ee>
2002-01-04 04:44:32 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-04 23:13:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-05 00:32:37 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-05 01:25:32 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
2002-01-05 01:44:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-05 17:54:29 from Hannu Krosing <hannu(at)tm(dot)ee>
2002-01-05 21:44:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-06 12:01:44 from Ashley Cambrell <ash(at)freaky-namuh(dot)com>
2002-01-06 22:32:40 from Hannu Krosing <hannu(at)krosing(dot)net>
2002-01-07 01:37:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-06 23:12:07 from Hannu Krosing <hannu(at)krosing(dot)net>
2002-01-07 02:32:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-07 07:01:15 from Hannu Krosing <hannu(at)tm(dot)ee>
2002-01-07 16:39:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-07 17:51:19 from Gilles DAROLD <gilles(at)darold(dot)net>
2002-01-08 02:20:30 from Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
2002-01-23 19:10:27 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-23 19:15:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-14 13:12:42 from Luis Amigo <lamigo(at)atc(dot)unican(dot)es>
2002-01-03 07:20:16 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2002-01-04 11:58:28 from Fredrik Estreen <estreen(at)algonet(dot)se>
2002-01-04 01:02:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2002-01-04 06:21:54 from Fredrik Estreen <estreen(at)algonet(dot)se>
2002-01-04 02:35:11 from Kenny H Klatt <kklatt(at)csd(dot)uwm(dot)edu>
2001-12-29 19:37:15 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-29 20:58:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-29 21:09:56 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-12-29 23:09:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-12-29 20:23:20 from "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
Lists:
pgsql-hackers pgsql-odbc
Fredrik Estreen <estreen(at)algonet(dot)se> writes:
> Here are some results for Linux 2.2 on a Dual PentiumPro 200MHz, SCSI
> disks and way too litte RAM (just 128MB).
Many thanks for the additional datapoints! I converted the data into
a plot (attached) to make it easier to interpret.
> I observed the loadavg. with the three different 7.2 versions and 50
> clients, without patch the load stayed low (2-3), with patch no1 very
> high (12-14) and with patch no2 between the two others (6-8).
That makes sense. The first patch would release more processes than
it probably should, which would translate to more processes in the
kernel's run queue = higher load average. This would only make a
difference if the additional processes were not able to get the lock
when they finally get a chance to run; which would happen sometimes
but not always. So the small improvement for patch2 is pretty much
what I would've expected.
> I could run benchmarks on 7.1 if that would be interesting.
Yes, if you have the time to run the same test conditions on 7.1, it
would be good.
Also, per recent discussions, it would probably be better to try to keep
the total number of transactions the same for all runs (maybe about
10000 transactions total, so -t would vary between 10000 and 200 as
-c ranges from 1 to 50).
regards, tom lane
Attachment: bench.gif
Description: image/gif (4.9 KB) (inlined above)
In response to
Responses
pgsql-hackers by date
Next :From: Gavin SherryDate: 2002-01-04 01:17:09Subject : Re: Updated TODO itemPrevious :From : Brent VernerDate : 2002-01-04 00:50:23Subject : Re: More problem with scripts
pgsql-odbc by date
Next :From: Kenny H KlattDate: 2002-01-04 02:35:11Subject : Transaction tests on SMP LinuxPrevious :From : Tom LaneDate : 2002-01-03 23:39:59Subject : Re: LWLock contention: I think I understand the problem
