X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id D12A3D1C988
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 28 Jul 2003 16:17:16 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 03074-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 28 Jul 2003 13:16:19 -0300 (ADT)
Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 4EE36D1C9B2
	for <pgsql-performance@postgresql.org>;
	Mon, 28 Jul 2003 13:17:14 -0300 (ADT)
Received: from tarzan ([68.96.211.236]) by lakemtao03.cox.net
	(InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP
	id <20030728161714.ITPY23518.lakemtao03.cox.net@tarzan>
	for <pgsql-performance@postgresql.org>;
	Mon, 28 Jul 2003 12:17:14 -0400
Message-ID: <000f01c35523$f13dee90$ecd36044@tarzan>
From: "Justin Long" <justinlong@strategicnetwork.org>
To: <pgsql-performance@postgresql.org>
Subject: Optimization
Date: Mon, 28 Jul 2003 12:18:55 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000C_01C35502.69E97930"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=BAYES_30,
	HTML_20_30
X-Spam-Level: 
X-Archive-Number: 200307/440
X-Sequence-Number: 2733

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C35502.69E97930
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Greetings,

I am trying to understand the various factors used by Postgres to optimize.=
 I presently have a dual-866 Dell server with 1GB of memory. I've done the =
following:

set /proc/sys/kernel/shmmax to 512000000
shared_buffers =3D 32000
sort_mem =3D 32000
max_connections=3D64
fsync=3Dfalse

Can someone tell me what effective_cache_size should be set to? what kind o=
f formula to use for this? (I got the other figures from phpbuilder.com, an=
d modified for 512k memory).=20

The databases I'm using have about 200,000+ news headlines with full-text i=
ndexes (which range upwards of a few million records). They are updated abo=
ut every 5 to 10 minutes, which means I also have to run a vacuum about onc=
e every 2 to 3 hours at least. As I get more updates obviously the efficien=
cy goes down. I'm trying to make the most of this system but don't fully un=
derstand PG's optimization stuff.

Thanks in advance,
Justin Long

------=_NextPart_000_000C_01C35502.69E97930
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.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Greetings,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to understand the various fact=
ors used=20
by Postgres to optimize. I presently have a dual-866 Dell server with 1GB o=
f=20
memory. I've done the following:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>set /proc/sys/kernel/shmmax to=20
512000000</FONT></DIV>
<DIV>shared_buffers =3D 32000<BR>sort_mem =3D=20
32000<BR>max_connections=3D64<BR>fsync=3Dfalse<BR></DIV>
<DIV><FONT face=3DArial size=3D2>Can someone tell me what effective_cache_s=
ize=20
should be set to? what kind of formula to use for this? (I got the other fi=
gures=20
from phpbuilder.com, and modified for 512k memory). </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The databases I'm using have about 200,000=
+ news=20
headlines with full-text indexes (which range upwards of a few million reco=
rds).=20
They are updated about every 5 to 10 minutes, which means I also have to ru=
n a=20
vacuum about once every 2 to 3 hours at least. As I get more updates obviou=
sly=20
the efficiency goes down. I'm trying to make the most of this system but do=
n't=20
fully understand PG's optimization stuff.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Justin Long</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_000C_01C35502.69E97930--