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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
