Re: Help optimize view - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Help optimize view
Date
Msg-id 46C03F8C.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Help optimize view  ("Relyea, Mike" <Mike.Relyea@xerox.com>)
Responses Re: Help optimize view  ("Relyea, Mike" <Mike.Relyea@xerox.com>)
List pgsql-performance
>>> 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




pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How to ENABLE SQL capturing???
Next
From: "Relyea, Mike"
Date:
Subject: Re: Help optimize view