DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=emRUBdM5TxaxoRhS5mAnWFXJtbr+CzTORUD6VSJVNr8iQWUmhj2DRJ1aSO44tmGKH2jzod2cNl9PtUForCDnY9wyY4Vmq+gLs0zIMU4L8X1kQlYryb8yUo7OYXyjgG8DyKdz1n3iC6elY+ejx+/CIvWXR2Eh9Q2OsukzJM2zlT4=
Message-ID: <7be3f35d0704281115l61a0e64rbabdd8e73149c015@mail.gmail.com>
Date: Sat, 28 Apr 2007 20:15:52 +0200
From: "Harald Armin Massa" <haraldarminmassa@gmail.com>
To: "Jonah H. Harris" <jonah.harris@gmail.com>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Cc: "Carlos Moreno" <moreno_pg@mochima.com>,
	"PostgreSQL Performance" <pgsql-performance@postgresql.org>
In-Reply-To: <36e682920704280954t1f42c51aya2f1899bf2ab892e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_242409_31118436.1177784152623"
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>
	<36e682920704280954t1f42c51aya2f1899bf2ab892e@mail.gmail.com>

------=_Part_242409_31118436.1177784152623
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Jonah,

Um, shared_buffers is one of the most important initial parameters to
> set and it most certainly cannot be set after startup.


Not after startup, correct. But after installation. It is possible to chang=
e
PostgreSQL.conf (not ini, to much windows on my side, sorry) and restart
postmaster.

Because a lot of good assumptions can be made on the initial install.
> Likewise, some of the most important parameters cannot be tuned after
> startup.


Yes. These assumptions can be made - but then they are assumptions. When th=
e
database is filled and working, there are measurable facts. And yes, that
needs a restart of postmaster, that does not work on 24/7. But there are
many databases which can be restartet for tuning in regular maintainance
sessions.

> :) which gives nice graphics and "optimized", like those Windows
> Optimizers.
> > :)  I am sure, some DBAs in BIGCOMPs would be thrilled :)
>
> >I'd suggest that you not make snide remarks about someone else's
> >design when your own analysis is somewhat flawed.


Sorry, Jonah, if my words sounded "snide". I had feedback from some DBAs in
BIGCOMPs, who said very positive things about the beauty of pgadmin. I saw
some DBAs quite happy about the graphical displays of TOAD. I worked for a
MVS Hoster who paid BIG SUMS to Candle Software for a Software called
Omegamon, which made it possible to have charts about performance figures.
So I deducted that people would even be willing to pay money for a GUI whic=
h
presents the opimizing process.

That idea of "tune PostgreSQL database after installation" also came from
the various request on pgsql-performance. Some ask before they install; but
there are also MANY questions with "our PostgreSQL database was running fas=
t
untill xxxx", with xxxx usually being a table grown bigger then n records.

And I really did not want to discredit the idea of properly configuring fro=
m
the start. Just wanted to open an other option to do that tuning.

Harald
--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra=DFe 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.

------=_Part_242409_31118436.1177784152623
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Jonah,<br><br><div><blockquote class=3D"gmail_quote" style=3D"border-left: =
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;=
">Um, shared_buffers is one of the most important initial parameters to<br>=
set and it most certainly cannot be set after startup.
</blockquote><div><br>Not after startup, correct. But after installation. I=
t is possible to change PostgreSQL.conf (not ini, to much windows on my sid=
e, sorry) and restart postmaster.  <br><br></div><blockquote class=3D"gmail=
_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt=
 0pt 0.8ex; padding-left: 1ex;">
Because a lot of good assumptions can be made on the initial install.<br>Li=
kewise, some of the most important parameters cannot be tuned after<br>star=
tup.</blockquote><div><br>Yes. These assumptions can be made - but then the=
y are assumptions. When the database is filled and working, there are measu=
rable facts. And yes, that needs a restart of postmaster, that does not wor=
k on 24/7. But there are many databases which can be restartet for tuning i=
n regular maintainance sessions.
<br><br></div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px s=
olid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">&gt=
; :) which gives nice graphics and &quot;optimized&quot;, like those Window=
s Optimizers.
<br>&gt; :)&nbsp;&nbsp;I am sure, some DBAs in BIGCOMPs would be thrilled :=
)<br><br>&gt;I&#39;d suggest that you not make snide remarks about someone =
else&#39;s<br>&gt;design when your own analysis is somewhat flawed.</blockq=
uote><div>
<br>Sorry, Jonah, if my words sounded &quot;snide&quot;. I had feedback fro=
m some DBAs in BIGCOMPs, who said very positive things about the beauty of =
pgadmin. I saw some DBAs quite happy about the graphical displays of TOAD. =
I worked for a MVS Hoster who paid BIG SUMS to Candle Software for a Softwa=
re called Omegamon, which made it possible to have charts about performance=
 figures.=20
<br>So I deducted that people would even be willing to pay money for a GUI =
which presents the opimizing process.<br><br>That idea of &quot;tune Postgr=
eSQL database after installation&quot; also came from the various request o=
n pgsql-performance. Some ask before they install; but there are also MANY =
questions with &quot;our PostgreSQL database was running fast untill xxxx&q=
uot;, with xxxx usually being a table grown bigger then n records.=20
<br><br>And I really did not want to discredit the idea of properly configu=
ring from the start. Just wanted to open an other option to do that tuning.=
<br><br>Harald<br></div></div>-- <br>GHUM Harald Massa<br>persuadere et pro=
grammare
<br>Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>70197 Stuttgart<br>0173=
/9409607<br>fx 01212-5-13695179 <br>-<br>Python: the only language with mor=
e web frameworks than keywords.

------=_Part_242409_31118436.1177784152623--