Re: Postgresql 7.4.8 inconsistent index usage - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Postgresql 7.4.8 inconsistent index usage
Date
Msg-id 20050708225356.GA3216@winnie.fuhr.org
Whole thread Raw
In response to Re: Postgresql 7.4.8 inconsistent index usage  (Stephen Bowman <stephenbb@gmail.com>)
List 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/

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgresql performance on Opteron 8 CPU
Next
From: Roy Souther
Date:
Subject: UPDATE from a SELECT on two fields.