Robert Treat wrote:
>
> I don't think there is any way to do it without restarting the server
> and using STATS_RESET_ON_SERVER_START from the postgresql.conf
>
> you might be able to do it by killing the stats collector process on
> your machine, but i cant recall if postmaster will automagically fire up
> a new collector or if you have to do something more involved. It might
> be worth trying on a development machine.
You can kill it and postmaster will fire up a new one, which ironically
reads in the data/global/pgstat.stat file if it exists, which on a busy
server get's recreated/overwritten every 500 milliseconds. You must
remove that file and kill the collector before it get's recreated ... so
semicolon is your friend ;-)
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #