Re: Strange performance issue

Thanks for confirming that

1 - there is a problem with 7.1.3 and I am not hallucinating, and
2 - it has been fixed!

It's possible that the 7.2 port won't work properly because of some
patch, I will test this after 7.2 enters the port tree as well.

Thanks for all the good work!

- Mike H.

X-Received-From: brent(at)mutt(dot)rcfile(dot)org
X-Delivered-To: mvh(at)ix(dot)netcom(dot)com
X-Spam-Filter: check_local(at)habanero(dot)hesketh(dot)net by digitalanswers.org
X-More-Information: http://spamfighter.hesketh.net
Date: Mon, 26 Nov 2001 13:30:31 -0500
From: Brent Verner <brent(at)rcfile(dot)org>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-general(at)postgresql(dot)org
Content-Disposition: inline
X-SpamBouncer: 1.4 (8/24/01)
X-SBClass: OK

On 26 Nov 2001 at 08:04 (-0800), Mike Harding wrote:
|
| I am using FreeBSD-4.4-STABLE, cvsup'd last weekend, and the version
| is 7.1.3 as reflected in the FreeBSD port system.
|
| I can try with 7.2beta, but it might be awkward as I only have a
| dial-up line... if somebody with 7.2 already installed could try this,
| you will almost certainly beat me to results.

Testing your case with postgres 7.2b3 on FBSD 4.4-STABLE, I do not
see what you described. Below is a copy of top(1) running while
running two instances of your script.

9507 brent 41 0 5172K 3376K RUN 0:11 37.17% 28.47% postgres
9508 brent 41 0 5172K 3376K RUN 0:11 36.98% 28.32% postgres
9506 brent 2 0 4196K 3072K select 0:02 5.42% 4.15% perl
9505 brent 2 0 4196K 3072K select 0:02 4.85% 3.71% perl

running the same against 7.1.3 top(1) shows

9575 pgsql -4 0 6044K 3480K semwai 0:04 0.88% 0.88% postgres
9574 pgsql -4 0 6044K 3484K semwai 0:04 0.73% 0.73% postgres
9580 pgsql -4 0 6044K 3484K semwai 0:01 0.70% 0.68% postgres
9579 pgsql 2 0 6044K 3484K select 0:01 0.15% 0.15% postgres

cheers.
brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman