Re: [PERFORM] WAL Optimisation - configuration and usage
Rod Taylor wrote: random_page_cost = 0.5 Try a value of 2 for a while. OK thanks Richard and Rod. I've upped this to 2. I think I left this over from a previous play with setttings on my IDE RAID 0 workstation. It seemed to have a good effect being set as a low float so it stuck. I've set it to 2. From another post off list, I've also bumped up max_fsm_relations = 1000 # min 10, fsm max_fsm_pages = 2 # min 1000, fs vacuum_mem = 32768 # min 1024 as they did seem a little low. I'm hesitant to set them too high at this stage as I'd prefer to keep as much RAM available for runtime at this time. I'm still hoping that perhaps the uber-pgadmin Mr Lane might reply about my WAL issue :) however I'm getting the feeling now the server is running with a much higher level of performance than it has been. Won't know until tomorrow thought. Cheers, -- Rob Fielding Development Designer Servers Ltd ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] FreeBSD config
Shridhar Daithankar wrote: Dror Matalon wrote: I've read Matt Dillon's discussion about the freebsd VM at http://www.daemonnews.org/21/freebsd_vm.html and I didn't see him saying that Freebsd uses all the free RAM for disk cache. Would you care to provide a URL pointing to that? Quoting from http://www.daemonnews.org/21/freebsd_vm.html : * When To Free a Page* Since the VM system uses all available memory for disk caching, there are usually very few truly-free pages... Got to say - a very interesting discussion you have all being having, I am now quite confused about what those vfs.*buf* variables actually do... Please feed back any clarfications from the FreeBSD experts to this list! regards Mark ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] FreeBSD config
On Mon, Mar 01, 2004 at 08:30:58PM +1300, Mark Kirkwood wrote: > > > Shridhar Daithankar wrote: > > >Dror Matalon wrote: > > > >>I've read Matt Dillon's discussion about the freebsd VM at > >>http://www.daemonnews.org/21/freebsd_vm.html and I didn't see him > >>saying that Freebsd uses all the free RAM for disk cache. Would you care > >>to provide a URL pointing to that? > > > > > > I noticed this passage too, but ... > Quoting from http://www.daemonnews.org/21/freebsd_vm.html : > > * > When To Free a Page* > > Since the VM system uses all available memory for disk caching, there ^ The VM system, as you can see from the article, is focused on paging and caching the programs and program data. Is the cache for disk reads and writes thrown into the mix as well? > are usually very few truly-free pages... > > > Got to say - a very interesting discussion you have all being having, I > am now quite confused about what those vfs.*buf* variables actually do... Same here. > > Please feed back any clarfications from the FreeBSD experts to this list! > > regards > > Mark > -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.fastbuzz.com http://www.zapatec.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
