Re: Test request for Stats collector performance improvement - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: Test request for Stats collector performance improvement
Date
Msg-id 002101c69051$ca9ff870$68c8a8c0@lerctr.org
Whole thread Raw
In response to Test request for Stats collector performance improvement  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
> Would some people please run the attached test procedure and report
> back the results?  I basically need to know the patch is an
> improvement on more platforms than just my own.  Thanks  
> 
>
---------------------------------------------------------------------------
> 
[snip]FreeBSD thebighonker.lerctr.org 6.1-STABLE FreeBSD 6.1-STABLE #60: Mon Jun
12 16:55:31 CDT 2006
root@thebighonker.lerctr.org:/usr/obj/usr/src/sys/THEBIGHONKER  amd64
$
with all stats on, except command string, cvs HEAD, no other patch:
$ sh stat.script       1.92 real         0.35 user         0.42 sys
$
# same as above, with command_string on.
$ sh stat.script       2.51 real         0.34 user         0.45 sys
$
#with patch and command_string ON.
$ sh stat.script       2.37 real         0.35 user         0.34 sys
$ 
The above uname is for a very current RELENG_6 FreeBSD.  This was done on a dual-xeon in 64-bit mode.  HTT *IS*
enabled.

LER

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US



pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Are we still interested in the master-slave scan patch
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Increasing catcache size