Re: postgresql.conf value need advice

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql.conf value need advice
Date: 2005-08-03 18:05:51
Message-ID: 1123092351.19874.70.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-08-03 18:11:49 Re: Note on scalar subquery syntax
Previous Message Peter Fein 2005-08-03 17:18:15 Re: Note on scalar subquery syntax