From: Carlos Moreno <moreno_pg@mochima.com>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: Sat, 28 Apr 2007 16:34:49 -0400
Message-ID: <4633AFE9.7080600@mochima.com> (raw)
In-Reply-To: <7be3f35d0704280131o6e6d2044n78c207e77b55f6a1@mail.gmail.com>
References: <OFC96167D5.6BB63AC2-ON652572C9.003B5263-652572C9.003E4142@lntinfotech.com>
<46310247.2050802@pinpointresearch.com>
<463158DD.3060602@mochima.com>
<2679.1177642153@sss.pgh.pa.us>
<4631FA55.4010406@mochima.com>
<7be3f35d0704280131o6e6d2044n78c207e77b55f6a1@mail.gmail.com>
Harald Armin Massa wrote:
> Carlos,
>
> about your feature proposal: as I learned, nearly all
> Perfomance.Configuration can be done by editing the .INI file and
> making the Postmaster re-read it.
>
> So, WHY at all should those parameters be guessed at the installation
> of the database? Would'nt it be a saver point of time to have some
> postgresql-tune
> utilitiy, which gets run after the installation, maybe every once in a
> while. That tool can check vital information like "Databasesize to
> memory relation"; and suggest a new postgresql.ini.
I would soooo volunteer to do that and donate it to the PG project!!
Problem is, you see, I'm not sure what an appropriate algorithm would
be --- for instance, you mention "DB size to memory relation" as if it is
an extremely important parameter and/or a parameter with extremely
obvious consequences in the configuration file --- I'm not even sure
about what I would do given that. I always get the feeling that figuring
out stuff from the performance-tuning-related documentation requires
technical knowledge about the internals of PG (which, granted, it's
out there, given that we get 100% of the source code ... But still, that's
far from the point, I'm sure we agree)
That's why I formulated my previous post as a Feature Request, rather
than a "would this be a good feature / should I get started working on
that?" :-)
Carlos
--
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: moreno_pg@mochima.com
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
In-Reply-To: <4633AFE9.7080600@mochima.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