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 #