Notes on Specific Logging and Locking Parameters
Note the following:
• There is no 6.4 equivalent to the Ingres log_writer parameter. Although the log_writer default is 1, it is usually advantageous to start your Ingres installation with log_writer set to 4 or 5. If you are using dual logging, double the setting.
• The default rule for computing lock_limit (and the new parameter resource_limit) tend to compute very high numbers-hundreds of thousands, or more. You can allow more locks than you did in 6.4. As an initial setting, a doubling of lock_limit is usually more than sufficient.
• Ingres 9.0 requires at least 35 log buffers. The install or upgrade will raise the log buffer count to a minimum of 35.
• Configurator may compute a different archiver_interval than you used in 6.4. Carry over the 6.4 setting.