Re: BUFFERS: How high is too high?

I reasantly added more memory (going from 80 to 144 MB) and set my BUFFERS to high. The performance immediately whent totaly down the drain. I was hardly able to get in and out of onmonitor, much less doing anything else. In my book swapping is the worst there is and should be avoided at (almost) any cost. You should of course not only "suspect" swapping, but use whatever tools you have to find the real rate of swapping activity. There are of course many other things to tune as well. Just search for David Williams posts on this theme (you may use www.dejanews.com) and you will learn allmost every trick there is. Neil Truby <ntruby@netcomuk.co.uk> wrote: :I'm running OnLine v7.13 on Solaris 2.4. I have 160M of physical memory :on my SunSparc 20, and have BUFFERS set to 20000 (or 40M). RESIDENT is :set to 1. The cache read rate is great (99.8%), and the write rate is :OK (~92%). Reducing the size of BUFFERS has in the past seen a drop in :the write cache percentage. : :Performance is crap, and I've recently noticed that my scanning rate is :very high. I suspect that some processes are swapping. So, is it :better to have the DBMS optimal and allow server processes to swap (thus :incurring swap I/O), or reduce the performance of the DBMS (thus :icreasing its write I/Os) and free up more memory for server processes? : :Thanks in advance for any comments :Neil Truby :Chase Manhattan Bank :Bournemouth, UK Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org