On Dec 14, 2009, at 8:55 AM, McCulloch, Stephen wrote:

It's only derived from qsf_guideline, which is probably set to medium. You can set qsf_guideline
to large, or you can simply set qsf_memory yourself. (The guideline is there to help people
who might otherwise be unsure as to what value to set qsf_memory to.) qsf_memory does not
affect any other parameters directly, that I can recall.

Karl

Betty & Karl Schendel wrote:

26Mb for the QSF pool doesn't seem obviously cramped, but there is no
harm enlarging it. You might like to see what is reported when you set
trace point QS501. It will report the fraction that is unused.
Provided you have ~20% free you should normally be OK.

Another thing to consider is that the SQF pool is local to a server
process, so running additional server processes may be helpful too.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.