Re: [GENERAL] Stats Collector

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Stats Collector
Date: 2002-07-30 19:46:12
Message-ID: 200207301946.g6UJkCJ15556@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Christopher Kings-Lynne wrote:
> > OK, now I run it and it does absolutely nothing to the pg_stat_all_tables
> > relation for instance. In fact, it seems to do nothing at all - does the
> > reset function even work?
>
> OK, I'm an idiot, I was calling the funciton like this: void blah(void)
> which actually does nothing.
>
> It all works now and I have just submitted it to -patches as a new contrib,
> but it probably should make its way into the backend one day.

OK, the big question is how do we want to make stats reset visible to
users? The current patch uses a function call. Is that how we want to
do it?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-30 19:55:38 Re: [GENERAL] Stats Collector
Previous Message Philip Hallstrom 2002-07-30 19:25:02 Re: PosgreSQL 10 things to know about ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2002-07-30 19:50:25 Re: WAL file location
Previous Message Bruce Momjian 2002-07-30 19:44:41 Re: START TRANSACTION