From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Stephen Bowman <stephenbb(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql 7.4.8 inconsistent index usage |
Date: | 2005-07-08 22:53:56 |
Message-ID: | 20050708225356.GA3216@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 08, 2005 at 03:06:29PM -0400, Stephen Bowman wrote:
>
> This is on a Xeon 3ghz with 2gb of RAM. There are 2 SCSI U/320 disks.
>
> For the variables, I have everything defaulted except for:
>
> shared_buffers = 20000
> effective_cache_size = 68916
>
> I just added random_page_cost=3 and it seems to have fixed it. Do the
> values I have set for these variables make sense with my hardware?
shared_buffers (156M) looks in line with various tuning guides'
recommendations given 2G of RAM; effective_cache_size (538M) might
(or might not) be low, depending on how much memory other processes
are using up. Tuning guides like the one I mentioned and the folks
in pgsql-performance should be able to help determine good values
to use.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Roy Souther | 2005-07-08 23:31:58 | UPDATE from a SELECT on two fields. |
Previous Message | Joshua D. Drake | 2005-07-08 22:30:34 | Re: Postgresql performance on Opteron 8 CPU |