postgresql.conf value need advice

Started by marcelo Cortezover 20 years ago2 messagesgeneral
Jump to latest
#1marcelo Cortez
jmdc_marcelo@yahoo.com.ar

folks

what is preferible value for
stats_reset_on_server_start ?

what is default value?

best regards
MDC

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam �gratis!
�Abr� tu cuenta ya! - http://correo.yahoo.com.ar

#2Ragnar Hafstað
gnari@simnet.is
In reply to: marcelo Cortez (#1)
Re: postgresql.conf value need advice

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