Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 10DF09F9B25
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 13 Aug 2007 13:25:29 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 53125-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 13 Aug 2007 13:25:22 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 3CD229F9C82
	for <pgsql-performance@postgresql.org>;
	Mon, 13 Aug 2007 13:25:21 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Mon, 13 Aug 2007 11:25:19 -0500
Message-Id: <46C03F8C.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Mon, 13 Aug 2007 11:25:01 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-performance@postgresql.org>, "Mike Relyea" <Mike.Relyea@xerox.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: Help optimize view
References: 
 <1806D1F73FCB7F439F2C842EE0627B18065BED58@usa0300ms01.na.xerox.net>
	<14336.1186782218@sss.pgh.pa.us>
	<1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>
In-Reply-To: 
 <1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/132
X-Sequence-Number: 26262

>>> On Mon, Aug 13, 2007 at 10:35 AM, in message
<1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>, =
"Relyea,
Mike" <Mike.Relyea@xerox.com> wrote:=20
> I'm running 8.2.4 on Windows XP with 1.5 GB memory.
> shared_buffers =3D 12288
> effective_cache_size =3D 10000
=20
For starters, you might want to adjust one or both of these.  It looks to =
me
like you're telling it that it only has 78.125 MB cache space.  That will
make it tend to want to scan entire tables, on the assumption that the =
cache
hit ratio will be poor for random reads.
=20
Since you're on 8.2.4, you can use units of measure to help make this =
easier
to read.  You could, for example, say:
=20
shared_buffers =3D 96MB
effective_cache_size =3D 1200MB
=20
-Kevin
=20