Re: Regression test for stats collector - Mailing list pgsql-patches

From Manfred Koizar
Subject Re: Regression test for stats collector
Date
Msg-id g9q2mvsh5a16hgs5osv6mksggcmjjs55kh@email.aon.at
Whole thread Raw
In response to Re: Regression test for stats collector  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
On Thu, 11 Sep 2003 23:17:13 -0400 (EDT), Bruce Momjian
<pgman@candle.pha.pa.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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Reorganization of spinlock defines
Next
From: Bruce Momjian
Date:
Subject: Re: Reorganization of spinlock defines