Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Changing the default configuration (was Re:

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>,PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>,pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Date: 2003-02-13 17:10:56
Message-ID: 200302131710.h1DHAui22918@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > So, my idea is to add a message at the end of initdb that states people
> > should run the pgtune script before running a production server.
> 
> Do people read what initdb has to say?
> 
> IIRC, the RPM install scripts hide initdb's output from the user
> entirely.  I wouldn't put much faith in such a message as having any
> real effect on people...

Yes, that is a problem.  We could show something in the server logs if
pg_tune hasn't been run.  Not sure what else we can do, but it would
give folks a one-stop thing to run to deal with performance
configuration.

We could prevent the postmaster from starting unless they run pg_tune or
if they have modified postgresql.conf from the default.  Of course,
that's pretty drastic.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-performance by date

Next:From: Chantal AckermannDate: 2003-02-13 18:06:03
Subject: cost and actual time
Previous:From: Tom LaneDate: 2003-02-13 15:06:29
Subject: Re: [HACKERS] Changing the default configuration (was Re:

pgsql-hackers by date

Next:From: mlwDate: 2003-02-13 17:13:00
Subject: Re: location of the configuration files
Previous:From: mlwDate: 2003-02-13 16:53:26
Subject: Re: location of the configuration files

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2003-02-13 18:49:06
Subject: Re: Changing the default configuration (was Re:
Previous:From: Tom LaneDate: 2003-02-13 15:20:20
Subject: Re: set_ps_display on solaris x86

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group