Just wondering how often the stats collector resets it self. Is this a parameter i can change?
At my knowledge each time that you do an analyze on your db your statistics are changed ( are not incremental I mean), anyway you can set to reset statistics at the start of postgres.
I think you're mixed up there. Stats collector is totally different thing.
The stats collector is never reset. You can reset it manually by going:
select pg_stat_reset();
And you can specify in the postgresql.conf that it should be reset on server restart if you like.
Chris
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
