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-16 01:34:12
Message-ID: e6t1qu$10k4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote
>
> Hm? I don't see any improvement there:
>

I was referening this sentence, though I am not sure why that's the
expectation:
>
> "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote
> If the patch worked, the first and third times will be similar, and
> the second time will be high.
>

-- 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 Chris Campbell 2006-06-16 01:40:22 Preventing DELETE and UPDATE without a WHERE clause?
Previous Message Olivier Thauvin 2006-06-16 00:59:30 Re: [Pgsqlrpms-hackers] ident auth vs. encrypting ident daemons

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-06-16 01:56:34 Re: Test request for Stats collector performance improvement
Previous Message Nikolay Samokhvalov 2006-06-15 22:22:23 Re: SQL/XML publishing function experimental patch II

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-06-16 01:56:34 Re: Test request for Stats collector performance improvement
Previous Message Merlin Moncure 2006-06-16 01:03:56 Re: Performance of pg_dump on PGSQL 8.0