Skip site navigation (1) Skip section navigation (2)

Re: Regression test for stats collector

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Regression test for stats collector
Date: 2003-09-12 06:58:15
Message-ID: g9q2mvsh5a16hgs5osv6mksggcmjjs55kh@email.aon.at (view raw or flat)
Thread:
Lists: pgsql-patches
On Thu, 11 Sep 2003 23:17:13 -0400 (EDT), Bruce Momjian
<pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>> The stats collector is on by default (of course, that doesn't apply to
>> "make installcheck"...)

By doing "appropriate" changes to your installation I guess you can
break almost every test ;-)

>Oh I see now, nice. I didn't realize you could turn it on per backend.

stats_start_collector and stats_reset_on_server_start "cannot be
changed after server start".

stats_command_string, stats_block_level, and stats_row_level can be
set per backend.

The test starts with
+SHOW stats_start_collector;  -- must be on
+ stats_start_collector
+-----------------------
+ on
+(1 row)
so that, if the test fails, you can look at the diff and have a chance
to tell whether the stats collector is not activated or not working
properly.

BTW, the test succeeds on 7.3.4, but the patch won't apply cleanly.
If anybody is interested, the patch for 7.3.4 can be fetched from
http://www.pivot.at/pg/25-TestStats_734.diff .

Servus
 Manfred

In response to

pgsql-patches by date

Next:From: Marc G. FournierDate: 2003-09-12 13:08:13
Subject: Re: [PATCHES] Reorganization of spinlock defines
Previous:From: Bruce MomjianDate: 2003-09-12 04:59:22
Subject: Re: [HACKERS] Reorganization of spinlock defines

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group