postgresql.conf runtime statistics default

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: postgresql.conf runtime statistics default
Date: 2005-06-09 10:08:52
Message-ID: 20050609100852.GA16538@zoom.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

after having migrated a 7.2 pg-database to 7.4 while upgrdaing from
debian woody to debian sarge there are some more conf-Parameters to
evaluate.
We are running a small but continuously growing datawarehouse which has
recently around 40 million fact entries.

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?

Regards,
Yann

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dennis Bjorklund 2005-06-09 10:48:07 Re: Query plan changes after pg_dump / pg_restore
Previous Message Jona 2005-06-09 09:23:14 Re: Query plan changes after pg_dump / pg_restore