Re: Improving postgresql.conf

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improving postgresql.conf
Date: 2004-06-11 17:15:50
Message-ID: 1086974150.31155.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2004-06-11 at 11:02, Bruce Momjian wrote:
> Gaetano Mendola wrote:
> [ PGP not available, raw data follows ]
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Bruce Momjian wrote:
> >
> > | Gaetano Mendola wrote:
> > |
> > |>Bruce Momjian wrote:
> > |>
> > |> > I understand your points below. However, the group has weighed in the
> > |> > direction of clearly showing non-default values and not duplicating
> > |> > documentation. We can change that, but you will need more folks
> > |> > agreeing with your direction.
> > |>
> > |>I don't remember the behaviour but tell me what happen if
> > |>I comment out a value changing the value. Kill UP the postmater.
> > |>Recommenting that value and now re killing the postmaster.
> > |>
> > |>I believe that postmaster will not run with the default value.
> > |>Who will look the configuration file will not understand the right
> > |>reality.
> > |
> > |
> > | If you comment a variable in postgresql.conf, it will use the
> > | default value.
> >
> > That's not true at least with the version 7.4.2.
> >
> > Try yourself, I did the experiment changing the cpu_tuple_cost and
> > commenting out the cpu_tuple_cost, after sending the SIGHUP to
> > postmaster the value remain: 0.005 that is not the default value at
> > all.
>
> Oh, sorry, you are right. Not sure if this is a bug or not.

This point has come up before, and I think it's intended behavior.
Stopping and restarting the database will, of course, make it load the
defaults.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Manfred Koizar 2004-06-11 17:24:31 Re: Another unpleasant surprise using inheritance
Previous Message Bruce Momjian 2004-06-11 17:07:24 Re: Compiling libpq with VisualC