Thread: postgresql.conf value need advice

postgresql.conf value need advice

From
marcelo Cortez
Date:
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

Re: postgresql.conf value need advice

From
Ragnar Hafstað
Date:
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