Re: Strange performance issue - Mailing list pgsql-general

From Brent Verner
Subject Re: Strange performance issue
Date
Msg-id 20011126183031.GA9513@rcfile.org
Whole thread Raw
In response to Re: Strange performance issue  (Mike Harding <mvh@ix.netcom.com>)
Responses Re: Strange performance issue  (Francisco Reyes <lists@natserv.com>)
Re: Strange performance issue  (Mike Harding <mvh@ix.netcom.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Mike Harding
Date:
Subject: Re: Strange performance issue
Next
From: "Mark Muffett"
Date:
Subject: Problem with the mailing list?