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

Re: Feature Request --- was: PostgreSQL Performance Tuning

From: Carlos Moreno <moreno_pg(at)mochima(dot)com>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: 2007-04-28 20:34:49
Message-ID: 4633AFE9.7080600@mochima.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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
--


In response to

pgsql-performance by date

Next:From: Mauro N. InfantinoDate: 2007-04-28 20:43:01
Subject: Re: Very specific server situation
Previous:From: Andres RetzlaffDate: 2007-04-28 19:28:14
Subject: Re: Usage up to 50% CPU

pgsql-general by date

Next:From: chrisjDate: 2007-04-28 20:41:49
Subject: tsearch2 and english locale on Debian - english.0 english.1
Previous:From: Rich ShepardDate: 2007-04-28 19:46:57
Subject: CONSTRAINT name With Domain As Check

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