X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0B48C9FA5E9 for ; Thu, 15 Jun 2006 05:01:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66449-02 for ; Thu, 15 Jun 2006 05:00:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by postgresql.org (Postfix) with ESMTP id D9B249FA4C1 for ; Thu, 15 Jun 2006 05:00:51 -0300 (ADT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lerami; d=lerctr.org; b=K3L9/xysnC8lLeEBAx02ew2lQ/pV1xqn28VpQy5w3f+6rWoxJRMO+g0W8zy4/WBeDJe8Cho0o8TkJZqUuvc9skx02s5SWiUgQJ7GjX+egy9xwSP5dXHiEOhtvTi2bX3+9Ozv1ASQLE5WtEdidrwpBYDqivFOD8mZqGj+NyCE28c=; Received: from adsl-70-240-13-227.dsl.austtx.swbell.net ([70.240.13.227]:2158 helo=lerlaptop) by thebighonker.lerctr.org with esmtpsa (TLSv1:RC4-MD5:128) (Exim 4.62 (FreeBSD)) (envelope-from ) id 1FqmmP-000I7v-7e; Thu, 15 Jun 2006 03:00:43 -0500 From: "Larry Rosenman" To: "'Bruce Momjian'" , "'PostgreSQL-development'" Cc: "'Tom Lane'" , "'Michael Fuhr'" , "'Merlin Moncure'" , "'Carlos Benkendorf'" 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> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcaQMQ/UnRHTIphJTZuUDXcYgJRXdgAIF0cA In-Reply-To: <200606150405.k5F45cH11445@candle.pha.pa.us> X-LERCTR-Spam-Score: -4.4 (----) X-LERCTR-Spam-Report: (-4.4 points, 5.0 required) ALL_TRUSTED=-1.8 BAYES_00=-2.599 DomainKey-Status: no signature X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/740 X-Sequence-Number: 84973 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