Re: Strange performance issue - Mailing list pgsql-general

From Mike Harding
Subject Re: Strange performance issue
Date
Msg-id 20011126190401.8DD70135B0@netcom1.netcom.com
Whole thread Raw
In response to Re: Strange performance issue  (Brent Verner <brent@rcfile.org>)
List pgsql-general
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@mutt.rcfile.org
   X-Delivered-To: mvh@ix.netcom.com
   X-Spam-Filter: check_local@habanero.hesketh.net by digitalanswers.org
   X-More-Information: http://spamfighter.hesketh.net
   Date: Mon, 26 Nov 2001 13:30:31 -0500
   From: Brent Verner <brent@rcfile.org>
   Cc: tgl@sss.pgh.pa.us, pgsql-general@postgresql.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


pgsql-general by date:

Previous
From: "Elizabeth O'Neill"
Date:
Subject: Timing a query
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: Row Limit?