E. Features Introduced in Ingres 9.2 : DBMS Server Enhancements : Improved Out of the Box Defaults
 
Share this page                  
Improved Out of the Box Defaults
Ingres has new defaults for the following configuration parameters, set during installation.
The default page size (default_page_size) for tables is changed from 2K to 8K.
The default buffer cache size (cache_guideline) is configured as medium for all page sizes, resulting in increased size for the following page sizes:
For 8K page size, increased from 16 MB to 48 MB.
For 32K page size, increased from 12 MB to 48 MB.
For 64K page size, increased from 11 MB to 48 MB.
DMF Cache 2K and 8K are enabled by default.
The default transaction log file size (II_LOG_FILE_SIZE_MB) is changed from 32 MB to 256 MB. The required minimum log file size is increased from 16 MB to 32 MB.