Re: Stats Collector

Christopher Kings-Lynne wrote:
> 
> Is there any way of resetting the stats collector without restarting
> Postgres?  I want all the pg_stat_* tables to have zero for everything
> again...

Hmmm,

there is a special control message for the collector to do so, and a
function that sends it exists too. But there is absolutely no way to
call it =:-O

Looks to me, someone forgot something. That would be me and now I
remember that I originally wanted to add some utility command for that.

What you need in the meantime is a little C function that calls 

void pgstat_reset_counters(void);

I might find the time tomorrow to write one for you if you don't know
how.


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #