Re: [GENERAL] Stats Collector - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [GENERAL] Stats Collector
Date
Msg-id 200207301946.g6UJkCJ15556@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Stats Collector  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: [GENERAL] Stats Collector  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Why is MySQL more chosen over PostgreSQL?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Stats Collector