Re: Test request for Stats collector performance improvement

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Test request for Stats collector performance improvement
Date: 2006-06-15 15:57:36
Message-ID: 200606151557.k5FFva918328@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance

Tom Lane wrote:
> "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> writes:
> > Obviously it matches your expectation.
>
> Hm? I don't see any improvement there:
>
> > --Before patch --
> > real 0m1.149s
> > real 0m1.121s
> > real 0m1.128s
>
> > -- After patch --
> > real 0m1.275s
> > real 0m4.063s
> > real 0m1.259s

The report is incomplete. I need three outputs:

stats off
stats on
stats on, patched

He only reported two sets of results.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-15 16:01:05 Descriptions for catalog tables
Previous Message Tom Lane 2006-06-15 15:19:04 Re: ADD/DROP INHERITS

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2006-06-15 15:58:30 Re: SQL/XML publishing function experimental patch II
Previous Message Bruce Momjian 2006-06-15 15:56:43 Re: SQL/XML publishing function experimental patch II

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-15 15:59:29 Re: Precomputed constants?
Previous Message Jim C. Nasby 2006-06-15 15:54:20 Re: Postgres fsync off (not needed) with NetApp