| From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
|---|---|
| To: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'PostgreSQL-development'" <pgsql-hackers(at)postgreSQL(dot)org> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Michael Fuhr'" <mike(at)fuhr(dot)org>, "'Merlin Moncure'" <merlin(dot)moncure(at)rcsonline(dot)com>, "'Carlos Benkendorf'" <carlosbenkendorf(at)yahoo(dot)com(dot)br> |
| Subject: | Re: Test request for Stats collector performance improvement |
| Date: | 2006-06-15 08:00:27 |
| Message-ID: | 002101c69051$ca9ff870$68c8a8c0@lerctr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
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(at)thebighonker(dot)lerctr(dot)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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-06-15 08:01:16 | Re: Increasing catcache size |
| Previous Message | Qingqing Zhou | 2006-06-15 06:15:32 | Re: Are we still interested in the master-slave scan patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-15 14:27:33 | Re: Test request for Stats collector performance improvement |
| Previous Message | Qingqing Zhou | 2006-06-15 06:09:43 | Re: Test request for Stats collector performance improvement |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nis Jorgensen | 2006-06-15 08:15:02 | Re: Is it possible to start two instances of postgresql? |
| Previous Message | kah_hang_ang | 2006-06-15 07:24:35 | Re: Is it possible to start two instances of postgresql? |