On Wed, 2005-08-03 at 13:30 -0300, marcelo Cortez wrote: > folks > > what is preferible value for > stats_reset_on_server_start ?
depends on whether you want stats to be accumulated for longer periods than between restarts. I imagine that 'on' is what most people need. in any case, you can reset stats with the function pg_stat_reset() > what is default value? the default is 'on' see http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-STATISTICS gnari ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
