Re: Test request for Stats collector performance improvement

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Test request for Stats collector performance improvement
Date: 2006-06-15 19:58:27
Message-ID: 4491BBE3.7070805@kaltenbrunner.cc
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

OpenBSD 3.9-current/x86:

without stats:
0m6.79s real 0m1.56s user 0m1.12s system

-HEAD + stats:
0m10.44s real 0m2.26s user 0m1.22s system

-HEAD + stats + patch:
0m10.68s real 0m2.16s user 0m1.36s system

Stefan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-06-15 20:29:06 ident auth vs. encrypting ident daemons
Previous Message Tom Lane 2006-06-15 19:18:05 Re: Remove the limit on the number of entries allowed in catcaches,

Browse pgsql-patches by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2006-06-15 20:29:36 Re: Test request for Stats collector performance improvement
Previous Message Bruce Momjian 2006-06-15 19:15:01 Re: Free WAL caches on switching segments

Browse pgsql-performance by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2006-06-15 20:29:36 Re: Test request for Stats collector performance improvement
Previous Message John Vincent 2006-06-15 19:43:09 Re: Optimizer internals