From: Richard Huxton <dev@archonet.com>
To: Yann Michel <yann-postgresql@spline.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgresql.conf runtime statistics default
Date: Thu, 09 Jun 2005 14:11:22 +0100
Message-ID: <42A83FFA.3030209@archonet.com> (raw)
In-Reply-To: <20050609100852.GA16538@zoom.spline.inf.fu-berlin.de>
References: <20050609100852.GA16538@zoom.spline.inf.fu-berlin.de>
Yann Michel wrote:
>
> To my question: I found the parameter "stats_reset_on_server_start"
> which is set to true by default. Why did you choose this (and not false)
> and what are the impacts of changeing it to false? I mean, as long as I
> understood it, each query or statements generates some statistic data
> which is used by the optimizer (or anything equal) later on. So in my
> oppinion, wouldn't it be better so set this parameter to false and to
> enable a kind of a "startup reset_stats" option?
This is administrator statistics (e.g. number of disk blocks read from
this index) not planner statistics. You're right - it would be foolish
to throw away planner stats.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, yann-postgresql@spline.de
Subject: Re: postgresql.conf runtime statistics default
In-Reply-To: <42A83FFA.3030209@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox