X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 3CE5311F6AD4
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 30 Mar 2006 09:57:08 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 86640-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 30 Mar 2006 09:57:08 -0400 (AST)
X-Greylist: delayed 01:05:14.597765 by SQLgrey-
Received: from mxfep02.bredband.com (mxfep02.bredband.com [195.54.107.73])
	by postgresql.org (Postfix) with ESMTP id 790B611F6A9E
	for <pgsql-performance@postgresql.org>;
	Thu, 30 Mar 2006 09:57:04 -0400 (AST)
Received: from server.kregert.se ([85.225.9.50] [85.225.9.50])
	by mxfep02.bredband.com with ESMTP
	id <20060330125148.RWZC29994.mxfep02.bredband.com@server.kregert.se>
	for <pgsql-performance@postgresql.org>;
	Thu, 30 Mar 2006 14:51:48 +0200
Received: from knatte (knatte.kregert.se [10.10.0.9])
	by server.kregert.se (8.13.5/8.13.4) with SMTP id k2U975mF018171
	for <pgsql-performance@postgresql.org>; Thu, 30 Mar 2006 11:07:05 +0200
Message-ID: <00b201c653da$a4409670$09000a0a@kregert.se>
From: "Mattias Kregert" <mattias@kregert.se>
To: <pgsql-performance@postgresql.org>
Subject: Automatic tuning of postgresql.conf parameters?
Date: Thu, 30 Mar 2006 11:16:34 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00AF_01C653EB.67ADC820"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200603/619
X-Sequence-Number: 18056

This is a multi-part message in MIME format.

------=_NextPart_000_00AF_01C653EB.67ADC820
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have noticed that a lot of people have a hard time finding out how to =
tune postgresql to suit their hardware.

Are there any tools for automatic tuning of the parameters in =
postgresql.conf? A simple program running some benchmarks on cpu & disk =
speed, checking the amount of ram and so on and then suggesting =
random/seq access cost, vacuum cust, sortmem/cache settings and so on? A =
pg_tune utility?

Maybe it could even look at runtime statistics/usage logs and help set =
the number of shared buffers, chekpoints, autovacuum...?

/Mattias (using the default config)

------=_NextPart_000_00AF_01C653EB.67ADC820
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have noticed that a lot of people =
have a hard=20
time finding out how to tune postgresql to suit their =
hardware.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Are there any tools for automatic =
tuning of the=20
parameters in postgresql.conf? </FONT><FONT face=3DArial size=3D2>A =
simple program=20
running some benchmarks on cpu&nbsp;&amp; disk speed, checking the =
amount of ram=20
and so on and then suggesting&nbsp;random/seq access&nbsp;cost, vacuum =
cust,=20
sortmem/cache settings and so on? A pg_tune utility?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Maybe it&nbsp;could even look at =
runtime=20
statistics/usage logs and help set the number of shared buffers, =
chekpoints,=20
autovacuum...?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>/Mattias (using the default =
config)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00AF_01C653EB.67ADC820--