Re: Test request for Stats collector performance improvement

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Test request for Stats collector performance improvement
Date: 2006-06-15 06:09:43
Message-ID: e6qtjn$22ui$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance


"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> 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
>

Obviously it matches your expectation.

uname: Linux amd64 2.6.9-5.13smp #1 SMP Wed Aug 10 10:55:44 CST 2005 x86_64
x86_64 x86_64 GNU/Linux
compiler: gcc (GCC) 3.4.3 20041212
configure: '--prefix=/home/qqzhou/pginstall'

--Before patch --
real 0m1.149s
user 0m0.182s
sys 0m0.122s

real 0m1.121s
user 0m0.173s
sys 0m0.103s

real 0m1.128s
user 0m0.116s
sys 0m0.092s

-- After patch --

real 0m1.275s
user 0m0.097s
sys 0m0.160s

real 0m4.063s
user 0m0.663s
sys 0m0.377s

real 0m1.259s
user 0m0.073s
sys 0m0.160s

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2006-06-15 06:15:32 Re: Are we still interested in the master-slave scan patch
Previous Message Josh Berkus 2006-06-15 05:54:15 Re: Are we still interested in the master-slave scan patch

Browse pgsql-patches by date

  From Date Subject
Next Message Larry Rosenman 2006-06-15 08:00:27 Re: Test request for Stats collector performance improvement
Previous Message Pavel Stehule 2006-06-15 05:04:02 Re: return can contains any row or record functions

Browse pgsql-performance by date

  From Date Subject
Next Message kah_hang_ang 2006-06-15 06:34:51 Re: Is it possible to start two instances of postgresql?
Previous Message A. Kretschmer 2006-06-15 06:07:36 Re: Is it possible to start two instances of postgresql?