From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-performance@postgresql.org
To: Mike Relyea <Mike.Relyea@xerox.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Help optimize view
Date: Mon, 13 Aug 2007 11:25:01 -0500
Message-ID: <46C03F8C.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>
References: <1806D1F73FCB7F439F2C842EE0627B18065BED58@usa0300ms01.na.xerox.net>
<14336.1186782218@sss.pgh.pa.us>
<1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>
>>> On Mon, Aug 13, 2007 at 10:35 AM, in message
<1806D1F73FCB7F439F2C842EE0627B18065BF2C0@USA0300MS01.na.xerox.net>, "Relyea,
Mike" <Mike.Relyea@xerox.com> wrote:
> I'm running 8.2.4 on Windows XP with 1.5 GB memory.
> shared_buffers = 12288
> effective_cache_size = 10000
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.
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:
shared_buffers = 96MB
effective_cache_size = 1200MB
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, Mike.Relyea@xerox.com, tgl@sss.pgh.pa.us
Subject: Re: Help optimize view
In-Reply-To: <46C03F8C.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox