Re: Strange performance issue

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