Re: Postgresql 7.4.8 inconsistent index usage

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/