I added a bunch of memory 2 Gig to my server.
Id like to know what to set the pervasive cache memory setting to.
 
anything over the default value presented to me by the machine causes only about a 70 meg cache.
 
If I set it to the default   about 500 meg I get that size.
 
is that it is it maxed out ?
 
I have about 800 meg of files in the default database so I think I should be setting the cache so a gig or so right ??
 
anyway its running much faster now cache was only 80 meg before !
 
J Dub

The First time PSQL 2000i runs after initial installation, it sets the default cache size
to 20% of total system RAM.  This is what the 2000i documentation says.  It never changes that even if  
you install additional memory.
 
It depends on what other applications on your server may request memory.  Ours is very stable, no applications are launched
and closed on a regular basis, there is no one on the console,  
and free physical memory says pretty consistent.
 
Our server has 785Meg (also NT 4 sp6) and we always have about 150 meg free physical memory.
Our Cache is set to 260Meg.  This is more than 20%, but we always have plenty of free physical memory.