From: Larry Rosenman <ler@lerctr.org>
To: 'Bruce Momjian' <pgman@candle.pha.pa.us>
To: 'PostgreSQL-development' <pgsql-hackers@postgreSQL.org>
Cc: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'Michael Fuhr' <mike@fuhr.org>
Cc: 'Merlin Moncure' <merlin.moncure@rcsonline.com>
Cc: 'Carlos Benkendorf' <carlosbenkendorf@yahoo.com.br>
Subject: Re: Test request for Stats collector performance improvement
Date: Thu, 15 Jun 2006 03:00:27 -0500
Message-ID: <002101c69051$ca9ff870$68c8a8c0@lerctr.org> (raw)
In-Reply-To: <200606150405.k5F45cH11445@candle.pha.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ler@lerctr.org, pgman@candle.pha.pa.us, pgsql-hackers@postgreSQL.org, tgl@sss.pgh.pa.us, mike@fuhr.org, merlin.moncure@rcsonline.com, carlosbenkendorf@yahoo.com.br
Subject: Re: Test request for Stats collector performance improvement
In-Reply-To: <002101c69051$ca9ff870$68c8a8c0@lerctr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox